VBA- hide empty rows

[Kazdima]

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

 

[Yongle]

Are the "Projects" in separate worksheets?

How do you define an empty row?
- the row has no values in any columns?
- the row has no values in columns C:Z (define your columns)

 

[Kazdima]

Hello Yongle,

"Empty row"= means- there is now numbers (amounts in it), including "zero".
Yes, The row does not have values in any columns.
The row does not have values in rows D:S

Thank you