hmmm....i hope i can explain this:
i have columns A - AG in worksheet 2. in worksheet 2, cells A1:F499 have a
formula in them to pull the data from worksheet 1 and display it.
as time goes by, a client will paste info into worksheet 1, columns A:F.
currently i have data up until row 18 without any blank lines. but until
the client adds more data later into worksheet 1, rows 19 - 499 are blank.
when i run the macro as it is right now, it searches for duplicate entries
and highlights them green. however, since rows 19 - 499 have formulas in
them it turns all of those rows green too. and i don't want it to do that, i
only want to highlight the duplicate rows with actual data in them.
is this possible? should i just run the macro on worksheet 1 and delete (or
clear contents) or highlight from there instead of worksheet 2 where i have
formulas?
once i can (if i can) get the highlighting to work, i'll change to code to
actually delete the dup's.

thanks for your help, i really appreciate it,
sharon

"anilsolipuram" wrote:


Presently your code is stop executing duplicates if a row as no data at
column c, so I think it is stopping when no data is found.

What do you mean by last row?. Do you have blank rows between rows, a
blank row represent last row?.


--
anilsolipuram
------------------------------------------------------------------------
anilsolipuram's Profile: http://www.excelforum.com/member.php...o&userid=16271
View this thread: http://www.excelforum.com/showthread...hreadid=277948