Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding a Duplicate using Vb
Hi I'm trying to make a function which looks for duplicates using Vb.
Something like... 'BigRange is always in worksheet "Main" 'Cell is always in worksheet "Print" 'something like below Function DuplicateExists (BigRange as Range, Cell as Range) As Boolean DuplicateExists = FalseIf cell exists in big Range and cell < "" then DuplicateExists = True End if End Function I prefer not to pass "Cell" to a worksheet cell as I will be testing many Cells with this function and it will bog down Excel. Is there a speedy way to do this using Vb. I apologize about the re-post however I'm looking for the fastest Vb solution. -- Regards, Rocky McKinley |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding a Duplicate using Vb
Function DuplicateExists (BigRange as Range, Cell as Range) As Boolean if not isempty(cell) then if application.countif(BigRange,Cell) 0 then DuplicateExists = True End if End if End Function -- Regards, Tom Ogilvy "Rocky McKinley" wrote in message ... Hi I'm trying to make a function which looks for duplicates using Vb. Something like... 'BigRange is always in worksheet "Main" 'Cell is always in worksheet "Print" 'something like below Function DuplicateExists (BigRange as Range, Cell as Range) As Boolean DuplicateExists = FalseIf cell exists in big Range and cell < "" then DuplicateExists = True End if End Function I prefer not to pass "Cell" to a worksheet cell as I will be testing many Cells with this function and it will bog down Excel. Is there a speedy way to do this using Vb. I apologize about the re-post however I'm looking for the fastest Vb solution. -- Regards, Rocky McKinley |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding duplicate value | Excel Discussion (Misc queries) | |||
Finding duplicate records | Excel Worksheet Functions | |||
Finding Duplicate Entries | Excel Discussion (Misc queries) | |||
Need help with finding duplicate entries | Excel Worksheet Functions | |||
Finding duplicate data | Excel Worksheet Functions |