Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
making a range of cell formula absolute
Hi,
I would like to design some code so that I can select a range of cells containing formula that I wish to make absolute. I would ideally like it to function like the F4 key which allows the $ to be put in to absoute by row and column, row and finally column. The F4 key only does it for each precedent contained in the formula string and you have to select the one you want to change. However my code will not want to distinguish between precedents - I just want to absolute all of them in each cell contained in the selected range. Any help is appreciated....Chris |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
making a range of cell formula absolute
Look in VBA HELP for CONVERTFORMULA
-- Don Guillett SalesAid Software "Chris Gorham" wrote in message ... Hi, I would like to design some code so that I can select a range of cells containing formula that I wish to make absolute. I would ideally like it to function like the F4 key which allows the $ to be put in to absoute by row and column, row and finally column. The F4 key only does it for each precedent contained in the formula string and you have to select the one you want to change. However my code will not want to distinguish between precedents - I just want to absolute all of them in each cell contained in the selected range. Any help is appreciated....Chris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Making all references in a range absolute | Excel Discussion (Misc queries) | |||
Making cell reference absolute makes cell format text | Excel Worksheet Functions | |||
What is the shortcut key for making a cell reference absolute? | Charts and Charting in Excel | |||
Changing cell references in a Range to Absolute | Excel Discussion (Misc queries) | |||
Making Sum ranges Absolute | Excel Discussion (Misc queries) |