Is there something wrong with this?
 

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?

Is there something wrong with this?
 

The line of code works.

Might be a protection problem or a spelling problem with the tab name.
--
Gary''s Student - gsnu200806


"Solution4U" wrote:

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?

Is there something wrong with this?
 

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.
--
Regards,
The Code Cage Team
www.thecodecage.com/forumz


"Gary''s Student" wrote:

The line of code works.

Might be a protection problem or a spelling problem with the tab name.
--
Gary''s Student - gsnu200806


"Solution4U" wrote:

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?