Hi Alan,

Thanks for your reply.

Yes normally this is what i would do, however I use the worksheet as a form that users can enter data into. What I am trying to achieve is to be able to to populate the form with the info existing in the database so they can see what is there and either overwrite it or leave it if they think it is more current than what they have. Once they have edited all or some of the cells I have a button they can click to copy the combined or new data back to the database.

I thought I might be able to save 57 lines of code by having the cell reference in a list that VBA could use rather than having to put in the actual cell reference in the code.

Do you think this is possible?

Thanks again.