PDA

View Full Version : VBA: Insert cells without affecting formulas



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

gregw74
01-15-2009, 07:38 PM
All set.

I ended up finding another way to import my data eliminating the need to insert any new cells.