Good afternoon folks,

I'm struggling to find a solution to a problem and was wondering if anyone knew how I would get round this, I'm learning and utilising this forum to the best extent I can but this little step doesn't work for me.

I have a macro (one I found and changed to my needs), that calls another macro (that I recorded/edited). The Macro is a loop that loops, performs a task, and steps down to perform again.

Sub UpdateProgress()

    Application.ScreenUpdating = True
    
    Call ALL
    
      ' Select cell H10, *first line of data*.
      Range("H10").Select
      ' Set Do loop to stop when an last cell is reached.
      Do Until ActiveCell.FormulaR1C1 = "End"
         ' Insert your code here. Call Macro Needed
         Call CombineUpdates
         ' Step down 1 row from present location.
         ActiveCell.Offset(1, 0).Select
      Loop
      
    Application.ScreenUpdating = True
    
      MsgBox "Update Complete"
    
    
   End Sub
I think the solution may be something like: if cells(a,1) = "" then goto lastline

From what I understand it will step down a cell, if it is blank then it will go back a line in my code and not perform the task, stepping down another line and checking if blank and repeating.

Thanks in advance to anyone that can help!

Krist