Moving active cell in several opened windows

  • Thread starter Thread starter Andrei Zakharov
  • Start date Start date
A

Andrei Zakharov

Hi,

I have a worksheet opened in two windows: File:1 and File:2.
I do call
ActiveCell.Offset(1, 0).Activate
in VBA code to make active cell move one row down in the sheet. But this
occurs only in the one window, e.g. File:1.
How is it to make active cell move the same way in the other window?

Thanks.
 
Aviod using Activate. It is hard to follow the code. reference cells
directly.


set wk1 = workbooks("Book1.xls).sheets("Sheet1")
set wk2 = workbooks("Book2.xls).sheets("Sheet2")


wk1.Range("A3") = wk1.Range("B4")


move down rows

for RowCount = 3 to 10
wk1.Range("A" & Count) = wk1.Range("B" & (count+1))
next RowCount
 
Back
Top