Is there something wrong with this?

  • Thread starter Thread starter Solution4U
  • Start date Start date
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?
 
The line of code works.

Might be a protection problem or a spelling problem with the tab name.
 
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
Not statements and blank page printing 2
Well, how hidden is it ?? 4
Hide/Show Rows based on Cell Value with Data Validation 3

Back
Top