Hi,

can any please assist me with the macro code to find several column names in row 1 (which can be anywhere in the work sheet) and delete them e.g. date, month, code, amount etc

Any assistance would be greatly appreciated


Many thanks in advance



Bob


N.B. Excel version 2007