macro - hide rows

  • Thread starter Thread starter Will
  • Start date Start date
W

Will

I will try this again but I do not understand all the
lingo so please lead me.

Cells A2:A60 contain formulas that return a result of
either "" or a number. Question is - Could the result
of "" from that formula (say in A4) be enough to trigger
HIDING row 4 ?? I will unhide them as I need unless it is
possible at the same time to unhide row 4 should the
result of A4 ever become a number.
If possible please do tell. I went the wrong route before
by right clicking the sheet tab and going to view code.

Thanks greatly for any help........Will
 
One way that I found that worked for this is the following:

In the Sheet Code area,

Private Sub Worksheet_Calculate()
Dim ToHide as Integer
For ToHide = 2 to 60
If Cells(ToHide, 1).Value = "" Then
Rows(ToHide).Hidden = True
Else
Rows(ToHide).Hidden = False
End If
Next ToHide
End Sub


There may be other ways, but it worked for me. Hope it does the same
for you.
 
Will
Try the code below
Rajesh

Sub HideRows()
Dim RowNo As Integer
RowNo = 2
Cells.Select
Selection.EntireRow.Hidden = False
Cells(2, 1).Select
For i = 1 To 59
Cellvalue = Sheets(1).Cells(RowNo, 1).Value
If Cellvalue = "" Then
Add = ActiveCell.Address
Rows(RowNo).Select
Selection.EntireRow.Hidden = True
End If
RowNo = RowNo + 1
Next i
End Sub
 
Back
Top