well, you didn't give us your very complex and big formula to help you
write it to add 1 as you copy the formula down your range... so I will
suggest this:

In a distant range (say Z1:Z90) place the values 1-90 (use the auto
fill feature for this).

In your very complex and big formula, instead of entering
"=..........+1....." enter "........+$Z1....." and copy this down your
range of 90 cells (use the drag handle on the cell). The second cell
will be "=........+$Z2....." (which, of course, is a value of 2) and so
on up to Z90 (a value of 90).

could a very simple and small solution such as this work for you?

good luck

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=384647