Excel VBA

[fouling91]

Hi every one;
I'm looking for a VBA code capable of copying data from columns "C2:D227612" and pasting them into empty rows in "A3:B227612". For example: range C2:D2 must be pasted into A3:B3 (empty row) and repeat this for all 227612 data. I need to put the Longitude-Latitude contained in columns C and D just below each Longitude-latitude combination in columns A. Can You Help Me please

 

[fouling91]

Slight adjustment to the code:

Sub FillTheGaps()
    With ActiveSheet
        With Intersect(.UsedRange, .Range("A:B"))
            .SpecialCells(xlCellTypeBlanks).FormulaR1C1 = "=R[-1]C[2]"
            .Value = .Value
        End With
    End With
End Sub

It worked. Thank you very much

 

[dreid1011]

It worked. Thank you very much

Wonderful! Happy to help.