getting the selected range and active cell of a non active workshe
Hi,
If a sheet is not active, no cells have focus, none are active, none are
selected. You cannot use those properties on an inactive sheet.
If you want the address of the cell that would be active if the sheet was
selected then you can do this
Application.ScreenUpdating = False
Sheets("Sheet2").Select
Where = Selection.Address
Sheets("Sheet1").Select
MsgBox "The selected cell on Sheet2 is " & Where
Application.ScreenUpdating = True
With screenupdating being false you will not see sheet 2 being fleetingly
activated.
Mike
"GerryGerry" wrote:
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)
|