Thread: Determining the selected range in a worksheet that is not the active worksheet

Hello,

how can I determine what range is selected in a worksheet?

Application.selection returns only the selected range in the active sheet. But clearly range selections are remembered for each worksheet individually, and they even persist between Excel sessions. So the selected ranges must be saved with each worksheet.

I was looking for a worksheet.selection property, but such a property does not exist.

Thanks very much

Gantenbein

You can only know what range is selected in the active worksheet, if you want to do something in another sheet, "Select" cannot be used, what are you trying to do in another worksheet??