Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
You are now using exactly what Jon suggested as an alternative, but note he
said "into a variant" which is not the same as declaring a variant array. Regards, Peter T "Charles" wrote in message oups.com... Actually found the answer myself. I was declaring Addthestuff(x() as variant) instead of Assthestuff(x as variant) which works. Still don't know why but the code behaves normally Charles |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
combining cells and array from different sheets into an array to pass to IRR() | Excel Discussion (Misc queries) | |||
Pass an array to Rank | Excel Worksheet Functions | |||
How do I pass an array to a listbox? | Excel Programming | |||
How can I pass an array as TextToDisplay to a hyperlink? | Excel Programming | |||
Pass a variable from a class module | Excel Programming |