MrExcel Publishing
Your One Stop for Excel Tips & Solutions

absolute cell references

Posted by michael on February 09, 2002 5:40 PM

How can you change a block of cells from relative to absolute cell references. The F4 toggle seems to work only one cell at a time.

Posted by Paul B on February 09, 2002 8:31 PM

take a look at some code here
also ASAP utilities will do it

Posted by Ampleford on February 11, 2002 9:36 AM

I'm probably being naive here - but have you tried naming the series of cells as opposed to trying to use relative cell addressing ?

Or am I up the wrong tree altogether ?