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

Hi CRayF,

Try:

If Target.Address = "$AA$1" Then srcProgramSummaryWs.Activate

---
Regards,
Norman



"CRayF" <CRayF@discussions.microsoft.com> wrote in message
news:08513C9D-2F87-47A1-9354-21F399095382@microsoft.com...
> 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
>

thanks