ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to find what object type is returned from Selection property ? (https://www.excelbanter.com/excel-programming/278655-how-find-what-object-type-returned-selection-property.html)

Krzysztof Klimczak[_3_]

How to find what object type is returned from Selection property ?
 
Hi,

I need to check if the object returned by "Selection" property is "Range"
type.
Is there a way to find it out ?

Currently I've done it using "On Error Goto" handling exceptions but I do
not find this solution as satisfactory.

Regards,
Krzysztof



merjet

How to find what object type is returned from Selection property ?
 
I need to check if the object returned by "Selection"
property is "Range" type. Is there a way to find it out ?


MsgBox TypeName(Selection)

HTH,
Merjet




All times are GMT +1. The time now is 08:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com