View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default how to redim the type of variant element

Just do an explicit conversion in the call to the function or change the
function to expect a variant. I provided you a detailed answer in response
to your first posting of this question.

--
Regards,
Tom Ogivly

"lvcha.gouqizi" wrote in message
ups.com...
But how about this is a two dimension array of mixed data types?

My myDyn is like this

myDyn(1, index) are String, and
myDyn(2, index) are Date