error comes in my code for hiding/unhiding

**ss_bb_24** · 11-07-2008, 03:24 AM

Hi, I have used the below code to hide/unhide of row 40 & 41 according to the value of C39 cell "yes"/"no".

Please Login or Register  to view this content.

But I am getting error "run time error 424" & it says "object required. Then it gets debug to this line of this code "Select Case UCase(Taget.Value)".

Can anyone help me please. I hope I made it understandable for anyone.

**VBA Noob** · 11-07-2008, 03:37 AM

Spelling mistake. Missing the r in target. Also you need to use LCase as you're triggers (yes and no) are lower case

should be

Please Login or Register  to view this content.

VBA Noob

**ss_bb_24** · 11-07-2008, 04:17 AM

thanks a lot. It was my mistake.

**royUK** · 11-07-2008, 05:09 AM

Plase mark threads "Solved" in future

error comes in my code for hiding/unhiding

LinkBack

Thread Tools

Rate This Thread

Display

error comes in my code for hiding/unhiding

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions