View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tedpeterborough tedpeterborough is offline
external usenet poster
 
Posts: 1
Default 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