Re: $$Excel-Macros$$ How to recast a variant as an array in VBA

2011-09-08 Thread Venkat CV
Hi, See below links.. http://www.mrexcel.com/forum/showthread.php?t=32187 http://www.ozgrid.com/forum/showthread.php?t=69235page=1 http://www.cpearson.com/excel/vbaarrays.htm *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* On Wed,

$$Excel-Macros$$ How to recast a variant as an array in VBA

2011-09-07 Thread ShayneH
Is there a way to expose an array that is enclosed by a variant? Basically I have one function that returns a variant type which needs to be passed to another procedure that requires the parameter to be typed as a byte array. eg: Function UsuallyReturnsAnArray() As Variant the result, after