Thread: Claus code works on my data not on OP's data
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default Claus code works on my data not on OP's data
Hi Howard,

Am Wed, 14 Aug 2013 10:05:15 -0700 (PDT) schrieb Howard:

If you care to take a look, here is a link to my workbook with two sheets, OP Data and My Test.

Works on My Test, crashes on OP Data.

you have to define the range in column A correctly. It takes time to
search for not existing Xs.
Your data works in 23 sec, the OP's data in 9 sec.
Have a look:
https://skydrive.live.com/#cid=9378A...121822A3%21326
for the workbook "Royal Bank String"


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
Reply With QuoteReply With Quote