Unhide rows

[wafs]

I took the code for hiding rows and tried to reverse the code to unhide the rows. It does not work. Does anyone have any suggestions about unhidding rows and the being of code?

Do While Sheets(destsh).Range(reportlocation).Value = ""
Sheets(destsh).Range(reportlocation).EntireRow.UnHidden = True
m = m + 1
reportlocation = "A" + m
Loop

 

[Loomah]

this will unide all hidden rows on the sheet
ActiveSheet.Rows.Hidden = False

is that what you're after?

;-)

If a man says something and there are no women there to hear him, is he still wrong?
How do I get the best answers?​

 

[wafs]

Thanks