Thread: Find the word "total" in a cell, delete row or column
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Myrna Larson Myrna Larson is offline
external usenet poster
  
Posts: 863
Default Find the word "total" in a cell, delete row or column

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


On Thu, 21 Oct 2004 12:43:38 -0500, Lawlerd
wrote:


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

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

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

Reply With QuoteReply With Quote