Find cell based on formula result and delete contents

Hi everyone - Happy New Year to one and all!

I always seem to get bogged down with the things that 'should' be easy to do!

I have a formula generating a number in A1 and want to search for that number in column B and delete it when it's found. However, when I record the macro using 'Find' it just records the actual number that A1 contains rather than the contents of A1 no matter what they are.

Any assistance would be much appreciated.

Regards,

Chris.

Try

replaces A1 if found in Col B

Please Login or Register  to view this content.

VBA Noob

That's fantastic VBA Noob....thank you so much for taking the time.

Have a great weekend and 2007!

Chris.

No problem

You too

VBA Noob