Hello Pieter I am rather sceptical myself about Class things. I think that, at least to some extent, they are a case of mystery for mystery’s sake Som...
_(i) …. If your code runs through error handling, then it terminates normally so we're back to the original situation …. I am not sure what you are r...
Hello Pieter Cox I suppose the answer to your first question …. I have a feeling that I need to create a Class module to achieve this but would greatl...
Thanks for the clarification, I think I see what your saying. You make some good points. I suppose I agree with them, but I didn’t want to over compli...
I don’t understand the last bit of what you are saying. … and if it doesn't the code at the end won't run anyway … Huh? Never mind, But generally spea...
For example: This is an approach similar to yours last : You did do it …_ _... build up long row list in Excel column O , then take out duplicates, t...
Hello SoniboiTM, One small but important thing to start with. You have at the start of your macro Application.ScreenUpdating = False But you have f...
Hi From your screenshot it looks as if you may have missed one: _.__________________________________________________________________________...
Most of David’s problems originally arose because he was unknowingly using range object item referencing in this form ArrayMortality(j, l) , but he w...
RangeMortality(1, 1) is the incorrect way to use the Range Item Property like its proper way RangeMortality.Item(1, 1) , but I think you will usually ...
Hi David First, something important to remember: You can call your variables anything you like. The word you chose is completely arbitrary. For exa...
Hi _1) I see no attached file _2) ArrayMortality is a named range in the spreadsheet. So if you change ArrayMortality then you change the named range,...
Hi David. I don’t understand fully what you are on about. I am probably missing some information from you. Please always supply a workbook and tell...
That is what I dided it already, I thoughted that is what you meant? _.______________________- Or/ And this is what I think V...
Hello David For this to do is in VBA many ways. This can be just one alternative is. ' Sub Trashit() Rem 1 Workbooks info C...