#16
|
|||
|
|||
Has it yet been established that the "TRUE"s never change and that this column being static is acceptable? |
#17
|
||||
|
||||
Except for the code that inserts the new column, that's of no real consequence, as re-running the macro will update everything. Indeed, it would be possible to make an event-driven version of the code, so it runs automatically on any row that does get changed. Such a macro's execution would be far quicker than leaving Excel to recalculate 50000+ rows.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#18
|
|||
|
|||
Good points macropod I appreciate the statistics and feedback you provided. I need to update my code to get that last part now.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
VBA code for Microsoft Word macro — select text and insert footnote | ndnd | Word VBA | 10 | 01-06-2015 01:47 PM |
Help with IF or ELSE Formulas | tsaladyga | Excel | 4 | 07-23-2014 09:04 AM |
Search and replace/insert HTML code into Master File using tags | dave8555 | Excel | 2 | 02-23-2014 03:51 PM |
Need help with formulas please | paul_pearson | Excel | 0 | 03-20-2013 06:51 AM |
IF Formulas | mizzamzz | Excel | 1 | 07-08-2010 02:32 AM |