Wouldn't it be easier to just use
datafilterautofilter

--
Don Guillett
SalesAid Software

"luu980" wrote in
message ...

Does anyone know of or can write a macro which will highlight the entire
row of cells in which the values in A column are identical / repeats.

What I need is this, for example:

aaaa bbbb bbbb bbbb
aaaa dddd dddd dddd
aaaa cccc cccc cccc
1111 1111 1111 1111
mmmm xxxx xxxx xxxx
mmmm tttt tttt tttt
9999 9999 9999 9999
yyyy hhhh hhhh hhhh
yyyy iiii iiii iiii
0000 0000 0000 0000
ssss mnjk zzzz dddd
ssss fdfc ftgy edsw

Leaving me:

Thus the rows which contain 'aaaa', 'mmmm', 'yyyy', 'ssss' will be
highlighted because the values in Column A are identical to each other.


(Note, the highlight can all be one color, even though, for example:
'aaaa' and 'mmmm' are not identical values.


I don't know how to write macros at all and wasn't able to find one
that does this. I am eternally grateful or any help that can be
provided.


--
luu980
------------------------------------------------------------------------
luu980's Profile:
http://www.excelforum.com/member.php...fo&userid=6931
View this thread: http://www.excelforum.com/showthread...hreadid=532911