Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
I instruction to move to a different Worksheet
thanks
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
insert an instruction for users when a worksheet opens | Excel Discussion (Misc queries) | |||
What Instruction? | Excel Discussion (Misc queries) | |||
How do I delete an instruction box? | Excel Worksheet Functions | |||
Unable to Insert Worksheet/Move and copy worksheet Excel 2003 | Excel Worksheet Functions | |||
BAR CODE Instruction | Excel Programming |