Posted to microsoft.public.excel.misc
|
|
This has kept me up typing for hours...
Awesome! Thanks!!
"mphell0" wrote:
You need to make that reference static by placing a $ in front of them.
Then
when you copy them to other cells the reference will not change
If in A2 you have =A1 when you copy it to column B it will change to
=B1.
If you put =$A$1 when you copy it to B it remains =$A$1
--
mphell0
------------------------------------------------------------------------
mphell0's Profile: http://www.excelforum.com/member.php...o&userid=30153
View this thread: http://www.excelforum.com/showthread...hreadid=510467
|