Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have the code below and I keep getting this error meesage, "Select
Method of Range Class failed". I am trying to just side some column when a user clicks a button. Private Sub FirstChooser_Click() Application.ScreenUpdating = False Sheets("Model").Select Columns("P:Q").Select Selection.EntireColumn.Hidden = True Columns("S:T").Select Selection.EntireColumn.Hidden = True Range("O56").Select Application.ScreenUpdating = True End Sub Thanks for the help. Scott |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
Shorten code to apply to all sheets except a few, instead of individually naming them, and later adding to code. | Excel Programming | |||
Protect Sheet with code, but then code will not Paste error. How do i get around this. Please read for explainations.... | Excel Programming | |||
Modification in the CODE to HIDE rows and columns that start with ZERO (code given) | Excel Programming | |||
Excel code convert to Access code - Concat & eliminate duplicates | Excel Programming |