M
marc
I have a spreadsheet with 400 formulas.
How would I add the "$" afterwards to lock the cells
How would I add the "$" afterwards to lock the cells
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
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
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
J
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
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
J
Jon Peltier
Hey John -
When did you get here?
- Jon
When did you get here?
- Jon
John Mansfield said: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
J
Jon Peltier
John -
Never mind, I got mixed up and thought I was in a different forum.
- Jon
Never mind, I got mixed up and thought I was in a different forum.
- Jon