| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
cell references
I have a spreadsheet with 400 formulas.
How would I add the "$" afterwards to lock the cells |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert relative cell references to absolute cell references via amacro? | Excel Discussion (Misc queries) | |||
| Help with converting a block of cells with Absolute and mixed references to relative references | Excel Worksheet Functions | |||
| How to rename references from range names to cell references | Excel Discussion (Misc queries) | |||
| Changing Cell References To a Different Worksheet in the Same Cell | Excel Worksheet Functions | |||
| Transferring cell content between workbooks using cell references | Excel Discussion (Misc queries) | |||
Linear Mode
