Thread: How to check a Variant for its data type
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TBA[_2_] TBA[_2_] is offline
external usenet poster
  
Posts: 58
Default How to check a Variant for its data type
Windows 2k Pro
Excel 2000

I have a 1-dimensional array as Variant. The values are either a String or
an Integer. How do I loop through the array and check to see if a
particular value is a string or an integer?

Thanks!

-gk-


Reply With QuoteReply With Quote