This may work:-

Right clicjk the sheet tab - view code and paste in

Sub stantiate()
Dim myRange As Range
Set myRange = Range("C6:C29")
For Each c In myRange
If c.Value < "" Then
'<Do your stuff here
End If
Next
End Sub

Mike

"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.