Thread: Find matches in 2 cols using Collection vs Dictionary
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld[_2_] Ron Rosenfeld[_2_] is offline
external usenet poster
  
Posts: 1,045
Default Find matches in 2 cols using Collection vs Dictionary
On Tue, 17 Jan 2012 09:50:43 -0500, GS wrote:

Ron,
The function is NOT designed to be used as a worksheet function, but
rather by VBA as follows...

If Not StripDupes Then MsgBox "Error!" Else RunSomeOtherCode

--
Garry

My understanding is that doesn't matter. Your Function is still trying to modify worksheet cells, and that is probably where the error is coming from. Do you actually see the worksheet cells being written to when you run that function?
Reply With QuoteReply With Quote