I have a macro that I want to run automatically using a list in AD9 thru AD23 ( 20 names). The Macro uses the name to sort a sheet and gets it ready to email. What I am trying to do is to get it to use the list starting with the first name in AD9 and copy it to A2 then run the macro 1. Then...