There is no active cell if the sheet is not active.


"GerryGerry" wrote in message
...
Can one access the active cell of a non active sheet (without activating
it first) in VBA as well as the selected range?

any help much appreciated as always
(i'm using Excel 2003)