I am trying to select the first 14 in Row A which are adjacent to a blank cell within Row C

Public Sub filterBlanks()

With ActiveSheet.UsedRange

.AutoFilter Field:=2, Criteria1:=”=”

.Columns(1).SpecialCells(xlCellTypeVisible).Select

End With

End Sub

I got this far but can’t manage to get the selection of the 14 first appearing next blank, would appericate any help

I am trying to create a macro which can copy the first 14 adjacent numbers, in row “A” that appear next to a blank cell, in row “C”.