Automatically hide a row if it is empty

V

Vil

Hi,

I would like Excel to hide a couple of rows if a formula input in the cells
of that row results in "" and show them if the formula shows numbers. Has
anyone worked out how to do it?

Thanks
Steve
 
D

Daniel.C

Hi.
Paste the following code in the sheet module. It's assuming to check
formulae from cells A5:A10.

Private Sub Worksheet_Calculate()
Application.EnableEvents = False
For i = 5 To 10
If Cells(i, 1) = "" And Cells(i, 1).HasFormula Then
Rows(i).Hidden = True
Else
Rows(i).Hidden = False
End If
Next i
Application.EnableEvents = True
End Sub

HTH
Daniel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hide/Unhide row VBA 1
hide a row 2
Excel EXCEL - using a date dependant formula to hide rows 3
If cell empty delete row 1
Hide and Show Rows based on Cell Value 2
Code to Hide Rows 7
Can you create a formula to hide a row if a cell is blank? 2
show hide row if 4

Top