cell references

[marc]

I have a spreadsheet with 400 formulas.

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

 

[Jon Peltier]

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

 

[John Mansfield]

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

 

[Jon Peltier]

Hey John -

When did you get here?

- Jon

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

 

[Jon Peltier]

John -

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

- Jon