Macro inserts a column but dont update formulas in another sheet!
 

As described above,

Is there something I can add to my macro to stop the the cell
references being updated in another sheet that the data is input to?

Thanks in advance

Stuart

Macro inserts a column but dont update formulas in another sheet!
 

You could change your formulas to include =indirect().

Like =indirect("'sheet 1'!a1")

Or you could convert your formulas to text.
edit|replace
what: =
with: $$$$$
replace all

do your stuff
and then reverse the mass change.

Stuart wrote:

As described above,

Is there something I can add to my macro to stop the the cell
references being updated in another sheet that the data is input to?

Thanks in advance

Stuart

--

Dave Peterson