getting MACRO to loop until cell is empty

[El Conquistador]

I have created a MACRO that copies data from sheet2 A1 and pastes in in sheet1 range - "gunner". This causes changes in sheet3. The MACRO copies the info from sheet3 into a batch file and then it runs the batch file. The batch file goes to the folder named and creates a ZIP file.

Sheet2, column A is a list of file folders that need to be compressed. It is a large and changing list - ergo the MACRO.

I would like the MACRO to go through the process that I have outlined, then go back to sheet2, take the new entry and start the process over again, until column A is empty.

A long and drawn out way of saying that I need a "do loop", but I thought the more info I provide, the more assistance can be returned.

My code (sloppy and encumbered) is

Please Login or Register  to view this content.

[protonLeah]

Please Login or Register  to view this content.

[El Conquistador]

thanks, that works great!