Find the word "total" in a cell, delete row or column

[Lawlerd]

Hi,
With this statement, Set rng = Cells.Find("total", LookIn:=xlValues
LookAt:=xlPart), is there any way to LookIn:=xlvalues, LookAt:=xlPar
(but not include column A) ?

I need to exclude Column A when searching for "total" in any cells. I
this possible ?

Thanks for taking the time to answer my previous question..It i
GREATLY appreciated

 

[Myrna Larson]

Set SearchRng = Range("B:IV")
Set Rng = SearchRng.Find(.....