Quick question Finding a cell by interior color
 

Thanks in advance!!

I have Set a Range based on finding a cell that is shaded a certai
color. I have used the statement:

Application.FindFormat.Interior.ColorIndex = 24

If I am to Set any other Ranges after this one using "find", does th
FindFormat statement need to be cleared out?

I noticed when I use the find function on the command menu, th
previous search options are still selected. Is this also true whe
doing this through a macro?

I hope this makes sense...

--
Cel
-----------------------------------------------------------------------
Celt's Profile: http://www.excelforum.com/member.php...fo&userid=1941
View this thread: http://www.excelforum.com/showthread.php?threadid=53010

Quick question Finding a cell by interior color
 

Hi Celt,

Application.FindFormat.Clear
Should do the job ... if need be ...

HTH
Cheers
Carim

Quick question Finding a cell by interior color
 

Does this help:

Application.FindFormat.Clear

Application.FindFormat.Interior.ColorIndex = 6

Cells.Find(What:="", After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _
xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext,
MatchCase:=False _
, SearchFormat:=True).Activate

Application.FindFormat.Clear



"Celt" wrote:


Thanks in advance!!

I have Set a Range based on finding a cell that is shaded a certain
color. I have used the statement:

Application.FindFormat.Interior.ColorIndex = 24

If I am to Set any other Ranges after this one using "find", does the
FindFormat statement need to be cleared out?

I noticed when I use the find function on the command menu, the
previous search options are still selected. Is this also true when
doing this through a macro?

I hope this makes sense....


--
Celt
------------------------------------------------------------------------
Celt's Profile: http://www.excelforum.com/member.php...o&userid=19413
View this thread: http://www.excelforum.com/showthread...hreadid=530108

Quick question Finding a cell by interior color
 

Perfect!
Thanks for the help Carim and Access101 !!!


--
Celt
------------------------------------------------------------------------
Celt's Profile: http://www.excelforum.com/member.php...o&userid=19413
View this thread: http://www.excelforum.com/showthread...hreadid=530108