Hi I'm trying to make a function which looks for duplicates. Something
like...

Function DuplicateExists (BigRange as Range, Cell as Range) As Boolean
BigRange is always in worksheet "Main"
Cell is always in worksheet "Print"
DuplicateExists = False
'something like below
If cell exists in big Range and cell < "" then
DuplicateExists = True
End if
End Function

I tried worksheetfunction.countif but it didn't seem to want to take the
worksheetname with the range.
Ideas?

Regards, Rocky McKinley

countif should work just fine...

=COUNTIF(Rpint!E2:G15,Sheet1!C9)

whatever sheet you place this formula, it will return the
count of the value in sheet1C9 in the range E2:G15 on
sheet RPrint

Patrick Molloy
Microsoft Excel MVP

-----Original Message-----
Hi I'm trying to make a function which looks for
duplicates. Something
like...

Function DuplicateExists (BigRange as Range, Cell as
Range) As Boolean
BigRange is always in worksheet "Main"
Cell is always in worksheet "Print"
DuplicateExists = False
'something like below
If cell exists in big Range and cell < "" then
DuplicateExists = True
End if
End Function

I tried worksheetfunction.countif but it didn't seem to
want to take the
worksheetname with the range.
Ideas?

Regards, Rocky McKinley


.