View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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?