I instruction to move to a different Worksheet
These lines are already coded€¦
Dim srcProgramSummaryWs As Worksheet Set srcProgramSummaryWs = Sheets("ProgramSummary") When AA1 is selected I want to move from the current Worksheet to the srcProgramSummaryWs Worksheet€¦ How so I do this? If Target.Address = "$AA$1" Then €˜ needed instruction? End If |
I instruction to move to a different Worksheet
Hi CRayF,
Try: If Target.Address = "$AA$1" Then srcProgramSummaryWs.Activate --- Regards, Norman "CRayF" wrote in message ... These lines are already coded. Dim srcProgramSummaryWs As Worksheet Set srcProgramSummaryWs = Sheets("ProgramSummary") When AA1 is selected I want to move from the current Worksheet to the srcProgramSummaryWs Worksheet. How so I do this? If Target.Address = "$AA$1" Then ' needed instruction? End If |
I instruction to move to a different Worksheet
thanks
|
All times are GMT +1. The time now is 04:40 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com