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

  • Thread starter Krzysztof Klimczak
  • Start date
K

Krzysztof Klimczak

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Merging from an Excel file with graphics 1
Word macro that can call cells out of Excel for a find and replace 0
How to find default property for particular object. 9
Runtime error 2147467259 (80004005) method return address of object envelope failed 2
What are properties of Application.Caller? 3
Is there an object property that will return the file type? 6
Chart label alignment 0

Top