Andy,

Thank you for the reply.

When i step thru the macro using the debug mode "step into", i can clearly see that the myVar(s) are loading with the correct information, so i'm not sure how it is not storing the infromation. So how do you suggest that i change the macro, any help would be appreciated.

Thanks