I instruction to move to a different Worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Setting Row to be = to another Worksheet? 13
Global variables - where do you place them? 16
Use a variable anywhere in the workbook - How to create? 3
How to test Worksheet exists before trying to create it? 7
Detect when a Cell value has changed. Working too well :-( 4
My variable always says False when I set it to True? 2
Copying cells from on sheet to another sheet (via sheet module) 6
Using a variable in a formula 7

Back
Top