gregw74
01-15-2009, 02:00 PM
To those who can help, I would greatly appreciate it...
I have a spreadsheet with various formulas but when a specific VBA instruction runs intended to insert a new cell my existing formulas are updated to compensate for the cell insertion. In most cases this is desirable, but in the case of my VBA macro, I don't want the surrounding formulas to be updated when the macro inserts this new cell, is there anyway to prevent these formulas from being updated?
Thank you,
Greg
I have a spreadsheet with various formulas but when a specific VBA instruction runs intended to insert a new cell my existing formulas are updated to compensate for the cell insertion. In most cases this is desirable, but in the case of my VBA macro, I don't want the surrounding formulas to be updated when the macro inserts this new cell, is there anyway to prevent these formulas from being updated?
Thank you,
Greg