Hi. I would like to copy a column using the column name instead of a column reference. With reference to the code below, I would like to change the Autofilter field:=70 to a autofilter:= (to the name of the column) i.e date/time etc. And I would like to change the range command to include the name of the column instead of the BR10 or so. Thanks

Sheets("Overall - Basestock Lifting").Activate 
    Range("BR10").Select 
   Selection.AutoFilter Field:=70, Criteria1:="1" 
   Range("BU10").Select 
   Selection.AutoFilter Field:=73, Criteria1:="TRUE" 
   Range(Cells(14, 2), Cells(i, 3)).Select    Selection.Copy 
   Sheets("Gp I Lifting").Select    Range("A5").Select 
   Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, 
SkipBlanks:=False, Transpose:=False