| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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, |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How I can I open a small window within window | Excel Discussion (Misc queries) | |||
| Docking Project Explorer, Properties window and Code window in VBE | Setting up and Configuration of Excel | |||
| The window opens in a smaller window not full sized window. | Excel Discussion (Misc queries) | |||
| In Excel - how to delete new window created from window on tool ba | Excel Worksheet Functions | |||
| How do I undo the Excel, Window Menu, New Window command | Excel Discussion (Misc queries) | |||
Linear Mode
