VBA: Insert cells without affecting formulas

[gregw74]

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]

All set.

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