From the Immediate Window, Can I ?
 

I step through (F8) a great number of macros. As i do
can I quickly (in the immediate window) inquire into the
data type of a given variable?

in the Sub I have i = 3

to verify this later in the sub can I enter in the immediate window:

? i.datatype (return) << something like
integer < to display

TIA,

From the Immediate Window, Can I ?
 

Try:

?Typename(i)



--
Jim
"Jim May" wrote in message
...
I step through (F8) a great number of macros. As i do
can I quickly (in the immediate window) inquire into the
data type of a given variable?

in the Sub I have i = 3

to verify this later in the sub can I enter in the immediate window:

? i.datatype (return) << something like
integer < to display

TIA,

From the Immediate Window, Can I ?
 

?typename(i)


Jim May wrote:

I step through (F8) a great number of macros. As i do
can I quickly (in the immediate window) inquire into the
data type of a given variable?

in the Sub I have i = 3

to verify this later in the sub can I enter in the immediate window:

? i.datatype (return) << something like
integer < to display

TIA,

--

Dave Peterson

From the Immediate Window, Can I ?
 

Thanks Jim / Dave:
Hope you both have a great Christmas!!
Jim

"Dave Peterson" wrote:

?typename(i)


Jim May wrote:

I step through (F8) a great number of macros. As i do
can I quickly (in the immediate window) inquire into the
data type of a given variable?

in the Sub I have i = 3

to verify this later in the sub can I enter in the immediate window:

? i.datatype (return) << something like
integer < to display

TIA,

--

Dave Peterson