Is it possible to get cell contents from another sheet?
 

If you want to know what cell would be the active cell if you activated a
sheet which is not currently active, and you want to do that without
activating the sheet, then I don't believe their is anything provided in the
object model that would return that information.

You can set screenupdating = False,
activate the sheet, get the address of the active cell, then return to the
original sheet and set ScreenUpdating = True

would be a work around.

--
Regards,
Tom Ogilvy

"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.

Is it possible to get cell contents from another sheet?
 

Thanks to all who replied, especially Tom. You caught my drift. I didn't
think it was possible, but I will use your work around which I had thought of
also.

Again thanks.

"Tom Ogilvy" wrote:

If you want to know what cell would be the active cell if you activated a
sheet which is not currently active, and you want to do that without
activating the sheet, then I don't believe their is anything provided in the
object model that would return that information.

You can set screenupdating = False,
activate the sheet, get the address of the active cell, then return to the
original sheet and set ScreenUpdating = True

would be a work around.

--
Regards,
Tom Ogilvy

"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.