Rows(count & ":72").EntireRow.Hidden = True


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"tedpeterborough " wrote in
message ...
I have a particular problem I can't solve - I just want to know if what
I want to do is possible. I want to be able to hide certain rows. I
have a loop with a simple counter - once the loop is finished, I want
to hide from row=count to 72.

I have tried using a constant, and it doesn't work either.
The macro works if I substitute count with a number.

Rows("count:72").Select
Selection.EntireRow.Hidden = True


---
Message posted from http://www.ExcelForum.com/