I agree, variants are not the best solution but sometimes we need a quick easy way to get around issues and using a variant would work here.
Here's a better solution, try loading up an array and sending it instead. You can unload the array on the return an process each element as you wish. This will not only solve your limitation issue but also make your code run more efficiently. btw - the code in the original post did have an error handler. -------------- Original message -------------- From: Dennis Jensen <[EMAIL PROTECTED]> --- [EMAIL PROTECTED] wrote: > Try returning a Variant datatype. > While this is a possible solution it also means the variable you are using in the function to stack the names will need to be a Variant. And it should be noted that Variants are extreme memory hogs and this reason alone makes them not a nice data type. Further I have read numerous authors state that Variants should be used very sparingly and under rather specific situations which you can tell I agree with. But then to each their own I suppose. Still, I believe there is a much better solution that will help streamline things and accomplish your objective. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com [Non-text portions of this message have been removed] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessVBACentral/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/AccessVBACentral/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
