Help Needed, May have bitten off more than I can chew
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
|