The issue is after the myrow is delete the row count increments 1 and leaves extra rows.
I think I need to reset the row count after each delete but not sure how that works.
Loop through column A, and move cell value from myrow to previous row
For myRow = 2 To myLastRow
If...