View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MrHaugen MrHaugen is offline
external usenet poster
 
Posts: 1
Default "lock" fields so they don't change number while copying formulas?


I just can't get this straight.

Every time I copy a formula there are lots of reference fields on page
1 that I want to increase numbers, but the "static" information I got
on page 2 I want to lock so they do NOT increase.

I have about 6 of this in many of my formulas and I'm not exactly happy
to change this in fields from A1 to P40

Any suggestions more than welcome!


--
MrHaugen
------------------------------------------------------------------------
MrHaugen's Profile: http://www.excelforum.com/member.php...o&userid=36191
View this thread: http://www.excelforum.com/showthread...hreadid=560398