code change to refer to column name rather than column position

Hello all,

I have this code below that deletes any single occurrence of a customer number but the "Customer Numbers" must be in column A.

I would like to change the code below to instead look for the "Customer Number" column by name, rather than by column A. My "Customer Number" column will always be in row 1, but yet, it will be in a different column letter every time I run the report.

Please Login or Register  to view this content.

Thanks much!

How about:

Please Login or Register  to view this content.