Steven,

Activecell applies to the active window, so there is only one. You can get
the selection from any window though. Here is a post from Dave Peterson a
couple of days ago on this topic

-----------------------------------------------------------------------

If you look at VBA's help for Selection, you'll see that it applies to the
application or window object.

You'll have to go through one of them to get it.

MsgBox Windows(1).Selection.Address & "--" & Windows(1).Caption
MsgBox Windows(2).Selection.Address & "--" & Windows(2).Caption

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"steven" wrote in message
...
If the active worksheet is sheet1, is it possible to get the activecell
value in sheet2 without selecting it ?

Thank you