Hiding/Unhiding sheets and rows (An easy one for most of you....)

  • Thread starter Thread starter Dean Goodmen
  • Start date Start date
D

Dean Goodmen

That works great; however how would you hide multiple rows, or a range
of them?

I tried Rows("2:5").Entirerow.Hidden = True, but it did not work...
 
This should work:

For each R in Rows("2:5")
R.Entirerow.Hidden = True
Next

Greetings,
Bunu
 
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

Hiding/Unhiding Rows in a worksheet based on the value of a checkbox. 1
when certain rows are hidden, can I also hide a combobox? 6
Hiding / unhiding rows based on change of a cell 8
Hide rows using VBA based on cell value 0
Unhiding rows 3
Faster code to quickly hide several rows? 7
Hiding and unhiding rows with if statement macro 1
Unhide roes in a different worksheet - My code is not working 3

Back
Top