ExcelBanter - Type of Selection

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Type of Selection (https://www.excelbanter.com/excel-programming/369858-type-selection.html)

Zone

Type of Selection

I want to know what the user has selected, range, drawing object, etc.
This has been answered before, but I can't find the thread. TIA, James

Ken Johnson

Type of Selection

Zone wrote:
I want to know what the user has selected, range, drawing object, etc.
This has been answered before, but I can't find the thread. TIA, James

Hi James,

Check out...

TypeName(Selection)

Ken Johnson

Zone

Type of Selection

That's it. Thank you, Ken.
Ken Johnson wrote:
Zone wrote:
I want to know what the user has selected, range, drawing object, etc.
This has been answered before, but I can't find the thread. TIA, James

Hi James,

Check out...

TypeName(Selection)

Ken Johnson

Ken Johnson

Type of Selection

You're welcome James.

Ken Johnson

All times are GMT +1. The time now is 10:00 AM.