sheets("sheetA").range("a1").value=sheets("sheetb" ).range("a1")
or
sheets("sheetb").range("a1").copy sheets("sheetA").range("a1")

--
Don Guillett
SalesAid Software

"quartz" wrote in message
...
Is it possible to obtain the currently selected cell address from another
sheet (one not currently active) without actually activating that sheet OR
must you activate the sheet to obtain the selection?

For example, Sheet B is currently active. I want a macro that obtains the
currently selected cell on Sheet A without actually having to activate
Sheet
A.

Both sheets are in the same currently open file. If so how do you do this,
or can you?

Thanks in advance.