Hi,


Can any please advise me of the macro code needed to search a worksheet for a heading in row 1 called ‘Contract Type’ (if it exists) and delete any rows where there is the text ‘Fixed Price’ (if any exists) in any of the cells in that column

Any assistance would be greatly appreciated

Many thanks

Rob

N.B Excel version 2007