| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
changing lists of cells to absolute values using a macro
I need to change several lists of cells from normal(ie. cell A1 shows the
value in cell C4) I need to change that value to $C$4. I do it by clicking the cell and hitting F2 then F4. For a list of 20 cells. When I try to use a macro to perform this function(using relative reference or not)all it does is give me a list of 20 $C$4's. what am I doing wrong? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| changing absolute reference for range of cells | Excel Worksheet Functions | |||
| Changing Cells from Relative to Absolute Reference | Excel Discussion (Misc queries) | |||
| Absolute Values in Relative Cells | Excel Worksheet Functions | |||
| How do I sum the absolute values of a range of cells? | Excel Discussion (Misc queries) | |||
| changing multiple cells from relative to absolute reference | Excel Discussion (Misc queries) | |||
Threaded Mode
