John -

Never mind, I got mixed up and thought I was in a different forum.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Jon Peltier" wrote in message
...
Hey John -

When did you get here?

- Jon

"John Mansfield" wrote in
message ...
Assuming by "lock" you want to make the formulas contain absolute cell
references . . .

Below is VBA code that allows you to change absolute to relative and
relative to absolute cell references for all formulas within a range:

http://www.ozgrid.com/VBA/formula-ref-change.htm

--
John Mansfield
cellmatrix.net


"marc" wrote:

I have a spreadsheet with 400 formulas.

How would I add the "$" afterwards to lock the cells