| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Case select and sheet codename
Hi everyone,
I'm replacing all sheet tab names with sheet codenames in my project. I'm getting Runtime error 438. Object doesn't support this property or method. I'm guessing it's this part of the code. ??? Select Case sht.CodeName Case Sheet33, Sheet25, Sheet28, Sheet27 sht.Visible = xlVeryHidden Case Else sht.Visible = True End Select Hoping that someone can help :-) -- Thank you Annie |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fastest way to select a sheet codename | Excel Programming | |||
| Selecting Sheet By Codename | Excel Programming | |||
| Case without Select Case error problem | Excel Discussion (Misc queries) | |||
| Use of sheet codename in codeline - How? | Excel Programming | |||
Threaded Mode
