1. I have Column I, K, L which contain Values (no formulas/references)
2. I need each cell in those column to divide each value by corresponding # in column H. For example I2=10, macro needs to turn I2 = 10/H2. Then everything needs to be formated to 3 decimals. And I need the same to happen for each Cell in Column I, K, L. At the end those columns need to be hidden.
Here is the code that was written before (i'm getting an error in highlighted part):
Dim MyRange As Range, NewFormaula As String, Delim As Range
Dim Cell As Range
Dim MyString As String
Dim Format As Range
Dim ws As Worksheet
Application.Calculation = xlCalculationManual
Application.ScreenUpdating = False
Delim = "@"
For Each ws In Worksheets
Select Case ws.Name
Case "PBDay locks", "Total Locked Pipeline"
Set MyRange = ws.Range("I:I")........................
I have a Worksheet were I have a formula in cells from D5 to ALO5. That read "Hide" or "Unhide".
I would like the column to each hide individually hide if that column has "Hide" in in it. If it has "Unhide" in the column then it becomes visible again. The range of the columns match the formula cells which are "D" through "ALO".
The following code hides all columns in my worksheet from AG:IV if the value in row 37 is "Attendance". I really need the flip side of this procedure as well, though, i.e., to hide all columns from AG:IV if the value in row 37 is anything OTHER than "Attendance".
For a = 32 To 255 If Range("a37").Offset(0, a).Value = "Attendance" Then Range("a37").Offset(0, a).EntireColumn.Hidden = True Next a
I want to hide the row when value "x" is entered in column C
I tried this code in the sheet, but nothing happens.......
VB: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Column = 3 Then ThisRow = Target.Row If Not Target.Value = "" Then ThisRow.EntireRow.Hidden = True End If End If End Sub
So when a "x" is entered in cell (115,C), row 115 must be hidden. When a "x" is entered in cell((9,C) row 9 must be hidden to, and so on. When a cell in an other column is changed, the macro does not need to start.
I need a quick macro I can run to hide the columns if the formula result for cells B1:AA1 is "" (null) instead of text. This runs explicitly on Sheet2. Array VBA is still geek to me.
There are 2 sheets in the excel worksheet. in one sheet there would be drop downs the 2nd sheet will have 4 columns A,B,C,D) Depending on the selection in sheet1. If a1 = Y then columnA in the 2nd sheet should be hidden. If a1 = N then columnB in the 2nd sheet should be hidden. how can this be done..The key is the columns to be hidden are on a different sheet and that is where I am having the difficulty.
I would like to hide rows (A17:A180) based on the value in the cell. If the value in a specific cell is "X", hide the row...if anything else is in the column's cell (A17, etc), show it.
I was wondering if it is possible to hide a column(s) but still have data in that column be visible at the bottom of the spreadsheet. For example, if I hide column G can it only hide the column from rows 1 - 50 and then the column will appear after row 50?
I have a macro that hides row A80 (a grand total for adding numbers). But, if I were to insert, or delete a row, my macro continues to work, but no longer reflects the appropriate row "grand total" row and hides a blank one because of this shift. Can I somehow freeze a row in my macro so regardless of what is altered in previous rows, my macro will always hide my grand total row?
Is there any formula to hide a column based on a value . I know we can do that manually using hide and Unhide option. but I want this to be done dynamically without A MACRO.
In the attached sample spreadsheet, the row 3 (status) has either 0 or 1 that is feed from another sheet and change dynamically. I need to hide all columns with a value 0. In this sample columns B,D,H,I,J,N & P must be hidden.Suppose If the staus value is changed from 0 to 1 then the column must be displayed (unhide).
I have more than 50 different sheets with columns A to AA where i would like to hide all empty columns. If for example column K is empty auto hide column K. I also have rows 1, 2 & 3 which have headers which need to be ignored when checking the columns.
I'd like to create a command button Macro that will hide all the rows on a given worksheet where the values in a given column equal zero. I'd like to do this to make printing more manageable, so that only the relevant rows (with value>0) print.
I'm looking for a macro which hides a row when the value of the cell in the E column is 0, but makes sure it's NOT hidden when the value is 1. (For example; the value of the cell E5 is 0, so row 5 is hidden. The valude of E8 is 1, so row 8 remains).
I've been trying the following code, but it doesn't seem to work for me:
Sub EmptyTest() If E12 = "0" Then Rows("12:12").Select Selection.EntireRow.Hidden = True End If If E13 = "0" Then Rows("13:13").Select Selection.EntireRow.Hidden = True End If ... End Sub
( ... = and so on )
But that doesn't seem to work; it also hides the rows which have the value of 1 in the cell in the E column.
( The value of the cells under E is set by a formula to the value '1' or '0', not false or true or any of that sort. )
I've written a macro to unprotect a sheet, unhide columns and reprotect the sheet. It works fine with 2 out of 3 worksheets. I cant find any reason why it wont work in the one sheet....
I am trying to hide/unhide several columns by hitting a button. It's a pretty simple macro to do it once, but how do I get a button to hide on the first click, then unhide on the second?