How to Link on [Sheet(1) Window(1)] to [Sheet(2) Window(2)] ?

E

EagleOne

2003

I created a macro to open two Excel windows.

Sheet(1).Range("A1") is linked to Sheet(2).Range("A2")

The link is not a problem.

With two windows open, I would like to activate the link in In
window(1) and have the Link-To cell activate in Window(2).

Is this possible?

TIA EagleOne
 
Top