Macro paste in nth empty cell of a specific column

[roversam]

I have some information that I want to paste in a cell.

But the cell I want to paste the information into is the nth empty cell of a specific column. Where n can be any whole number. I know the column reference but not the row reference.

I know that I have to use a loop, but don't know exactly what to do?
How do I get to the nth empty cell?

 

[roversam]

Further, I want to save that row reference (in VBA's version of a variable I guess?) because I want to enter more columns of data after I have determined which row the data has to go into.

 

[mirabeau]

If your dataset isn't too large (say < 30,000 or so), maybe something like this?

Sub nthblank()
Dim n As Long, e, k As Long
n = 7
With Range("A:A")
    .Cells(Rows.Count).Font.Bold = True
For Each e In .SpecialCells(xlBlanks)
    k = k + 1
    If k = n Then
        e.Select
        Range("C1") = e.Address
        Exit For
    End If
Next e
    .Cells(Rows.Count).Font.Bold = false
End With
End Sub