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
Dim LR As Long, Found As Range LR = Range("A" & Rows.Count).End(xlUp).Row Set Found = Columns("A").Find(what:="(AUS)", LookIn:=xlValues, lookat:=xlWhole) If Not Found Is Nothing Then Rows(Found.Row & ":" & LR).Delete
Bookmarks