Error 2042

[Azuki]

Sub removeProjThatNetOff()




    Dim firstRowOfAddedProj
    Dim firstRowOfRemovedProj
    Dim colOfImpactOnDP
    
    
    Range("Delta_Ppln_Proj_raw[[#Headers],[Impact on Delta Pipeline]]").Select
    colOfImpactOnDP = Selection.Column
    Selection.End(xlToRight).Offset(0, 1).Select
    ActiveCell.FormulaR1C1 = "Sum of KPIs"
    Selection.Offset(0, 1).Select
    ActiveCell.FormulaR1C1 = "Net off to 0"
    Selection.Offset(1, 0).Select
    firstRowOfAddedProj = Selection.Row
    Selection.Offset(-2, 0).Select
    firstRowOfRemovedProj = Application.Match("In last year-end pipeline", colOfImpactOnDP, 0)

end sub

why do I keep getting error 2042

 

[AlphaFrog]

This is a column number. Not the entire column range of cells.
colOfImpactOnDP = Selection.Column

Try this...
colOfImpactOnDP = Selection.EntireColumn