Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a file with 10 diffrent tabs. Depending on the option button chosen
on the first tab, certain columns need to be hiddein or revealed on a second tab. I'm getting an 'application-defined or object-defined error' when it tries to select a range on the newly activated worksheet. Can someone tell me what I'm doing wrong? If Opt1 = True Then Range("SampleStrat").EntireRow.Hidden = False Range("UnstratSample").EntireRow.Hidden = True Worksheets("Sample Evaluation").Activate Range("StratEval").Select (This is where it errors out) Selection.EntireColumn.Hidden = False Range("UnstratEval").Select Selection.EntireColumn.Hidden = True Worksheets("Sample Calc").Activate -- JP |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can I sort without activating / selecting sheet? | Excel Programming | |||
Selecting/Activating Control Tools Combobox on Sheet | Excel Programming | |||
Subscript our of range when activating a worksheet | Excel Programming | |||
Selecting or Activating a cell. | Excel Programming |