Insert formulas in VBA code

macropod · #1 06-11-2015, 10:16 PM

Quote:

Originally Posted by NoSparks

Has it yet been established that the "TRUE"s never change and that this column being static is acceptable?

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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