cell references
 

I have a spreadsheet with 400 formulas.

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

cell references
 

Hmmm, better to do it as you go along. Why do you need to "lock" the
formulas? are you going to be dragging them around? If the formulas work
when you've finished writing them, is there really a reason to change them?

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


"marc" wrote in message
...
I have a spreadsheet with 400 formulas.

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

cell references
 

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

cell references
 

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

cell references
 

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