Thread: Find the word "total" in a cell, delete row or column
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lawlerd[_3_] Lawlerd[_3_] is offline
external usenet poster
  
Posts: 1
Default Find the word "total" in a cell, delete row or column

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

--
Lawler
-----------------------------------------------------------------------
Lawlerd's Profile: http://www.excelforum.com/member.php...fo&userid=1547
View this thread: http://www.excelforum.com/showthread.php?threadid=27057

Reply With QuoteReply With Quote