Assuming they're the columns you want to keep, one way you can try is:
Sub SrmWtrColumnCleanup()
'Find last column with data in Row 1
lastCol = Cells(1, Columns.Count).End(xlToLeft).Column
'Loop through columns, starting at the last one
For delCol = lastCol To 1 Step -1
'Delete columns with Name in Row 1
If Cells(1, delCol) <> "SAMPLENAME" _
And Cells(1, delCol) <> "SAMPDATE" _
And Cells(1, delCol) <> "METHODCODE" _
And Cells(1, delCol) <> "ANALYTE" _
And Cells(1, delCol) <> "Result" _
And Cells(1, delCol) <> "DL" _
And Cells(1, delCol) <> "UNITS" _
Then _
Cells(1, delCol).EntireColumn.Delete
Next
End Sub
Regards
Bookmarks