Thread: Using Variable in Rows(x:y) function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
  
Posts: 3,885
Default 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/
Reply With QuoteReply With Quote