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