Using Variable in Rows(x:y) function

  • Thread starter Thread starter tedpeterborough
  • Start date Start date
T

tedpeterborough

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
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to Unhide Rows 3
selecting rows using a variable 3
Row Count... 4
Speeding up Hide rows code 2
Hiding Rows and Columns in code 5
Using variables in Rows.Select 5
Search for cells that DO NOT contain specific text 4
Need to know what is wrong with this 3 line code (row hiding with conditional formati 5

Back
Top