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