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