loop thru column and highlight the rows
 

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...o&userid=31726
View this thread: http://www.excelforum.com/showthread...hreadid=557545

loop thru column and highlight the rows
 

Already answered for Maria.

"mariasa" wrote:


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...o&userid=31726
View this thread: http://www.excelforum.com/showthread...hreadid=557545