View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
CRayF CRayF is offline
external usenet poster
 
Posts: 115
Default 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