Automatically hide a row if it is empty

  • Thread starter Thread starter Vil
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

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

Write a macro that hides rows based on empty cells 3
Excel EXCEL - using a date dependant formula to hide rows 3
Help on Macro to hide empty rows 4
auto hide blank rows 1
Hide and Show Rows based on Cell Value 2
Hide/Unhide row VBA 1
How To Have A Cell Be Blank If... 2
How do I automatically hide "FALSE" rows? 14

Back
Top