VBA select between to workbooks

[jakobt]

Having two workbooks

WB1 stored under: C:\WBA.xlsx Sheet 1
WB2 stored under: C:\WB2.xlsx Sheet 1

Now I want to create a macro which first activates cell A1 in sheet 1 in WB1
and then by tabbing F8 in VBE selects cell A1 in sheet 1 in WB2

 

[Johnny Thunder]

When declaring your variables you can use the below

Dim wB as workbook, nWb as workbook

Set wB = Active Workbook
Set nwb= Workbooks.Open ("C:\WB2.xlsx")

And then just select wb for workbook 1 or nwb for workbook 2. Hope this helps.