If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.
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.
>
> 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
Linear Mode
