ExcelBanter - How to find out the data type of a variable in VBA ?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - How to find out the data type of a variable in VBA ? (https://www.excelbanter.com/excel-programming/309060-how-find-out-data-type-variable-vba.html)

Adrian[_7_]

How to find out the data type of a variable in VBA ?

Hi,
How do I find out the data type of a variable in VBA ? Thanks..

--
Regards,
Adrian

Norman Jones

How to find out the data type of a variable in VBA ?

Hi Adrian,

You can use the VBA TypeName function - syntax and examples in Help.

---
Regards,
Norman

"Adrian" wrote in message
...
Hi,
How do I find out the data type of a variable in VBA ? Thanks..

--
Regards,
Adrian

All times are GMT +1. The time now is 01:46 PM.