You could upload a workbook with sample date in to
www.savefile.com
and post the link

Mike

"G.R." wrote:

Mike,
Sorry to not get back to you sooner. 3 out of 5 times that I try to post or
reply, it just goes into the ether. Hopefully this one goes through.
Thanks very much for the reply -- and so quickly. Your solution of finding
all the OwnedFund rows first, adding them to a named range, and then
highlighting them all at once is much more elegant.
When I ran this, though, the only result was that the active cell when the
macro started is shaded green. Nothing else. I tried selecting column Q and
then running the macro. Ended up with column Q shaded green but nothing else.
I tried stepping through it and, from what I can tell, it is checking each
cell nine times (seems right, 9 tickers in OwnedFund array) then going on to
the next cell. I don't know how to tell if these cells are in column Q and
there are nearly a thousand rows, so i can't step through all of them to get
to the part of the macro that highlights.
Is there more info I can supply?
Thanks again for the time and attention.
Gordon
Fingers crossed the MS gods will allow this reply onto the board...