Home |
Search |
Today's Posts |
#12
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Clif
I appreciate the steps. I decided to go and look over some older projects I had done over the years and found a handy work-a-round for the Set Focus issue not working. I employed the Case Select argument with great results. On Error Resume Next Windows("WowSchedMaster.xls").Activate If Not Range("E2").Value Is Nothing Then Select Case True Case Target.Value = "Jan" Windows("WowSchedHistory - 2011.xls").Activate Sheets("Jan").Select Case Target.Value = "Feb" Windows("WowSchedHistory - 2011.xls").Activate Sheets("Feb").Select Etc......... Thx again |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Deleting Rows With Non-Needed Data between Needed Data | Excel Worksheet Functions | |||
Needed Help.. | Excel Worksheet Functions | |||
Help needed | Excel Worksheet Functions | |||
help needed | Excel Discussion (Misc queries) | |||
help needed | Excel Discussion (Misc queries) |