Copy error 1

[leewisener]

Well its probably not an error just a setting.

if I try and copy a formula it just keeps repeating the first value.

A1 1
A2 =1+a1
A3 =1+a2

Thats what should happen when I drag down the sheet, but instead it produces all 1's

anyone tell me what I have set wrong?

 

[AnotherHiggins]

Go to Tools > Options, then on the Calculation tab, tck the box beside Automatic.

[tt]_____
[blue]-John[/blue][/tt]

Help us help you. Please read FAQ181-2886 before posting.

 

[leewisener]

Thanks, that was it.

 

[AnotherHiggins]

Glad you got it sorted.


[tt]_____
[blue]-John[/blue][/tt]

Help us help you. Please read FAQ181-2886 before posting.