Posted to microsoft.public.excel.misc
|
|
Convert Relative to absolute address
Look at EDIT=Replace
"Yorke" wrote:
The problem I have is that I have a number of formulas refering to a relative
address and I wish to have them refer to absolute. I am trying to avoid
redoing all references by adding the $ to each one.
"Rick Rothstein (MVP - VB)" wrote:
How can I convert a relative address to an absolute address in Excel?
Put $ signs in front of the parts of the address that you want to be
absolute.
Rick
|