Lots of answers

for RowCount = 6 to 29
if isemptry(cells(RowCount,"C")) then exit for

Next RowCount

"Jeremy" wrote:

ok, I have code that will copy a sheet from on workbook to another. Now I
need to repeat that process over and over.

I need to look at c6 through c-29. When the cell it looks at isn't blank, I
need it to run my code. When it is blank (end of the list) I need it to stop.

Any help? I really appreciate it.