Why not use a formula:

=IF(ISNUMBER(C2),IF(COUNTIF($C$2:$C$35,C2)1,"dupl icate",""),"") will check
for numbers only.

"jhahes" wrote:


What I am trying to do is this

1. Go to column C of sheet1 and highlight from C2: to the last entry in
the column. ex(C35)

2. Name the selected Range "PurchaseOrderNumber"

3. Go to the first empty column - row 2 and put in this formula

=IF(COUNTIF(PurchaseOrderNumber,C2)1,"Duplicate", "")


4. Fill down this in the empty column to the corresponding last entry
in column C (see step1) ex (c35)

5. then have a message box to alert if there are any displays.


******** the only condition is ******
1. in the Column where the purchase order numbers are - some are
blank, some are text, and some are numbers.


I have tried to used the macro recorder for certain parts of the code
but I am stuck now.

I am basically trying to find if there are any duplicate numbers in
this range.


--
jhahes
------------------------------------------------------------------------
jhahes's Profile: http://www.excelforum.com/member.php...o&userid=23596
View this thread: http://www.excelforum.com/showthread...hreadid=520252