Hi, znalron@yahoo.com,

your description seems to differ from the file you posted (there are no formulas in there). If there´s a formula displaying 0 the line will be hidden.

For unhiding you should simplify the code to
Rows(intStartRow & ":" & intEndRow).EntireRow.Hidden = False
Ciao,
Holger