Using Variable in Rows(x:y) function
 

I have a particular problem I can't solve - I just want to know if wha
I want to do is possible. I want to be able to hide certain rows.
have a loop with a simple counter - once the loop is finished, I wan
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 = Tru

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

Using Variable in Rows(x:y) function
 

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

--
Regards
Frank Kabel
Frankfurt, Germany


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/

Using Variable in Rows(x:y) function
 

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/