I have the following code........for some reason i can not assign the range A1 to A26 to the integer defined array but i can for the variant defined array...........why?
Please Login or Register to view this content.
I have the following code........for some reason i can not assign the range A1 to A26 to the integer defined array but i can for the variant defined array...........why?
Please Login or Register to view this content.
Because the data stored in worksheet cells is data type Variant, which you cannot coerce en masse to any stronger data type (Integer, Long, Double, Boolean, ...).
Last edited by shg; 10-07-2011 at 01:54 PM.
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks