Excel: Mass change relative cell refs to absolute (more than F4)

[aduchnow]

In a large range of cells I would like to change all cell references to be
aboslute references (i.e. $A$1) from relative references (i.e. A1). The only
way to do this currently is to select each (of possibly hundreds) of cell
references and use the F4 key.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...43cae24&dg=microsoft.public.excel.programming

 

[Stefano Gatto]

I think another way of doing this is parsing the formulas, extracting the
addresses bits, and using the .Address method of Range to rewrite addresses
in absolute coordinates. But this is far too complex as an alternative to
F4... Therefore I agree with this suggestion.
Thanks!
Stefano Gatto

 

[aduchnow]

I did eventually program out some code that parsed the formulas - in fact, I
even put it in a pretty simple loop to make it cycle through a range of
cells. Therefore in the end it was not a big deal, but the problem could be
one encountered by an Excel novice (perhaps not familiar with VBA) with no
way out other than the tedious clicking.

Thanks!
aduchnow