Quick question RE: Finding a cell by interior color

[Celt]

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...

 

[Carim]

Hi Celt,

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

HTH
Cheers
Carim

 

[Guest]

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]

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