Replies

John,
Thanks for your effort. Believe it or not, MS solved the problem for me. The clue here is that the macro works fine when you step through it. This suggests a “timing issue”. All I had to do was to introduce a 1 second pause just prior to the offending line of code, and the macro finishes off fine.
With respect to the code you used to convert the text to numbers, I used paste special because I thought the loop might be slower. I will try your method.
Thanks again to you and Steve.

John,
Thanks for your effort. Believe it or not, MS solved the problem for me. The clue here is that the macro works fine when you step through it. This suggests a “timing issue”. All I had to do was to introduce a 1 second pause just prior to the offending line of code, and the macro finishes off fine.
With respect to the code you used to convert the text to numbers, I used paste special because I thought the loop might be slower. I will try your method.
Thanks again to you and Steve.

Steve,
The KB article seems to address the issue. The error message is certainly bang on. But I am not asking the sub-total method to add page breaks.
Nevertheless, I downloaded the hotfix from MS. It did not work and I have a call in to MS to help me double-check whether it is indeed the correct patch and if I installed it properly. I’ll keep you posted on this, if you wish.
Ross

Steve,
The KB article seems to address the issue. The error message is certainly bang on. But I am not asking the sub-total method to add page breaks.
Nevertheless, I downloaded the hotfix from MS. It did not work and I have a call in to MS to help me double-check whether it is indeed the correct patch and if I installed it properly. I’ll keep you posted on this, if you wish.
Ross

Steve,
Sorry, I added data to the original attachment and forgot to include it this time.
The attached file is the product of the macro up to the point of sub-totalling. It works beyond that point if you step through it, and if you run the “subt” macro separately. It just won”t run all at once. The run-time error is “Automation error The object invoked has disconnected from its clients.”
Ross

Steve,
Sorry, I added data to the original attachment and forgot to include it this time.
The attached file is the product of the macro up to the point of sub-totalling. It works beyond that point if you step through it, and if you run the “subt” macro separately. It just won”t run all at once. The run-time error is “Automation error The object invoked has disconnected from its clients.”
Ross

John,
I think I tried what you suggested, but the same error occurred.
Ross

John,
I think I tried what you suggested, but the same error occurred.
Ross

Steve,
I have used conditional formatting where I want exceptions to stand out. But in this case I need to isolate those records containing a match in an indeterminate number of cells, and there are almost 40,000 records. It’s the rows with no hits that are ultimately deleted.
Ross

Steve,
I have used conditional formatting where I want exceptions to stand out. But in this case I need to isolate those records containing a match in an indeterminate number of cells, and there are almost 40,000 records. It’s the rows with no hits that are ultimately deleted.
Ross

Thank you. Yes, that much I was able to figure.

Thank you. Yes, that much I was able to figure.

Steve,
Thanks a bundle – works like a charm.
Comparing your code to mine identifies a number of errors on my part.
Find has always given me trouble. But I will study your code carefully for future work.
Ross

Steve,
Thanks a bundle – works like a charm.
Comparing your code to mine identifies a number of errors on my part.
Find has always given me trouble. But I will study your code carefully for future work.
Ross

Hans,
Thanks for the quick response. Indeed, the range should be EzenetData, but that did not fix it. The code runs merrily along but does not find names it should!!
Ross