Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

"Unable to set Hidden property of Range class" error

Status
Not open for further replies.
ninjamyst

ninjamyst

Programmer
Jan 28, 2005
21
US
I have a form that hides/unhides rows/cols in a worksheet. I keep getting the error "Unable to set Hidden property of Range class" when I try to set usedRange.Rows(num).entireRow.hidden to something. This fails only for SOME range....
 
Sort by date Sort by votes
ninjamyst,

Maybe you can check if the range is not already hidden?

W.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

kapok1
  • Locked
  • Question
how to use vba to forbid "Worksheet Menu Bar" being selected
Replies
6
Views
343
kapok1
kapok1
remeng
  • Locked
  • Solved
Run-time error '429': ActiveX component can't create object From Excel to Word
Replies
9
Views
902
remeng
remeng
remeng
  • Locked
  • Helpful tip
Microsoft Office 365 Word Macro Causing a Project is unviewable error
Replies
1
Views
780
dhookom
dhookom
dgillz
  • Locked
  • Question
Back coloring an entire row if a duplicate is found in a dynamic range 1
Replies
18
Views
462
SkipVought
S
morechocolate
  • Locked
  • Question
run-tune error 3704 operation is not allowed when the object is codes: I don't think so.
Replies
7
Views
874
morechocolate
morechocolate

Part and Inventory Search

Sponsor

Back
Top