Is there something wrong with this?

S

Solution4U

I keep getting an error and the debugger takes me to this line:

Sheets("Checklist").Rows("3:42").EntireRow.Hidden = True

The error is this:

"Unable to set the Hidden property of the Range class"

What am I missing here?
 
G

Gary''s Student

The line of code works.

Might be a protection problem or a spelling problem with the tab name.
 
C

Code Cage Team

Another thing on top of Gary's suggestion is the worksheet may be in another
workbook? if so you will have to "Workbooks("MyOtherBook").activate if its
open.
 

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

Any ideas? 1
when certain rows are hidden, can I also hide a combobox? 6
Macro to Hide Rows 5
Unexplicable error 1
Hiding and unhiding rows with if statement macro 1
Hide/Show Rows based on Cell Value with Data Validation 3
Not statements and blank page printing 2
Hide rows using VBA based on cell value 0

Top