VBA- to hide empty rows

[Dan_K_2014]

Hello,


I am preparing Financial statements for many projects using the same pro-forma template on monthly basis (12 columns) and about 150 rows.
For some projects all rows will have numbers, for some projects may be 70% of rows are empty.

Is it possible to have a macro to hide empty rows that do not go manually to hide them?
Thank you.
Dan

 

[vletm]

Dan_K_2014
Yes ... one sample ...
Press [ Hide ]-button...

 

[Dan_K_2014]

Hi Vletm,

I will test it later and let you know if I have a problem.
Dan

 

[p45cal]

Sub blah()
For Each rw In ActiveSheet.UsedRange.Rows
  If Application.CountA(rw) = 0 Then rw.EntireRow.Hidden = True
Next rw
End Sub