loop thru column and highlight the rows

From: mariasa <mariasa.2a96nc_1151734807.2874_at_excelforum-nospam.com>
Date: Sat, 1 Jul 2006 01:19:59 -0500

hi guys,

my previous entry probably sounded a bit confusing so heres a simplified version of it.

i would like my macro to do the following in the current worksheet. go to column j and loop thru it. if it finds " GR " in the cell, it has to highlight the entire row (belonging to the cell with " GR " in it), if not it moves on till the end of the column j.

could u please help me?

Thanks so much in advance!
mariasa

-- 
mariasa
------------------------------------------------------------------------
mariasa's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=31726
View this thread: http://www.excelforum.com/showthread.php?threadid=557545

Received on Fri Jun 30 2006 - 23:19:59 PDT