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