Hi

it may sound a bit strange but is it possible to find, given a variable
name, how it has been declared e.g. string, double etc

i.e without simply finding the declaration statement

thanks

Tim

Take a look at the TypeName method in XL/VBA Help


In article ,
"Tim Childs" wrote:

Hi

it may sound a bit strange but is it possible to find, given a variable
name, how it has been declared e.g. string, double etc

i.e without simply finding the declaration statement

thanks

Tim

Hi

yes that does the trick - THANKS

Is it possible to determine in a similar way the scope of the declaration
e.g. whether it was a Dim or Public etc?
(Last question (today) - I won't bother you again!)

Thanks

Tim


"JE McGimpsey" wrote in message
...
Take a look at the TypeName method in XL/VBA Help


In article ,
"Tim Childs" wrote:

Hi

it may sound a bit strange but is it possible to find, given a
variable
name, how it has been declared e.g. string, double etc

i.e without simply finding the declaration statement

thanks

Tim