Find function to reference a cell rather than fixed workd

[cmb80]

Hello all, I have some VBA code that currently looks for the word (AUS) in Column A and then delete text found after it.

Instead of the word (AUS) I would like the code to search for what is in Cell AM1. IS it possible to reference the cell within VBA please?

My code is below

Please Login or Register  to view this content.

[karedog]

Hi,

Yes, like this :

Please Login or Register  to view this content.

[berlan]

Try this:

Please Login or Register  to view this content.