02-03-2010, 05:59 PM
Ok as I say riddle me this batman. I am new to quick macros and have created a small one that works great. Here is my dillema, I want to open a user interface , which I have done, then I want to go excel move to a certain spot on the page, Completed, Now if that spot is empty stop running code if is not finish running the code then move down to the next line and start running code again. I want it to check column D and keep copying column D and pasting into a user interface in a non microsoft window, but then come back to the same spot in excel move down one and check if its empty before moving one basically. If not empty copy and paste again, if is empty then stop. If you know excel VBA I want wat to do a DO LOOP UNTIL ACTIVECELL.VALUE = "". Thanks.