I need a procedure that will unhide all the hidden rows on a worksheet.

I cannot figure out how to do this.

The main stumbling block is detecting whether any rows on the worksheet and
which ones they are. Assume the hidden rows are continguous.

Any ideas?

Thank you.

John Wirt

If you want to unhide ALL rows on a sheet then you do not need to know which,
if any, are hidden. Simply

Rows("1:" & Rows.Count).EntireRow.Hidden = False

Hope this helps
Rowan

"John Wirt" wrote:

I need a procedure that will unhide all the hidden rows on a worksheet.

I cannot figure out how to do this.

The main stumbling block is detecting whether any rows on the worksheet and
which ones they are. Assume the hidden rows are continguous.

Any ideas?

Thank you.

John Wirt

Hi John,

Alteratively, try:

Cells.Rows.Hidden = False


---
Regards,
Norman



"John Wirt" wrote in message
...
I need a procedure that will unhide all the hidden rows on a worksheet.

I cannot figure out how to do this.

The main stumbling block is detecting whether any rows on the worksheet
and
which ones they are. Assume the hidden rows are continguous.

Any ideas?

Thank you.

John Wirt