Excel Formula help - capture the 1st result

[mtrend]

Hi,

Is it possible to get a single cell in Excel to just run a forumla once.

I need to keep the first result without it being over written. Currently when other factors change the formula re-run's, overwriting the original result.

What I need is a way to capture the result when the formula triggers the 1st time ie. no matter what happens there after I have the 1st result captured.

Any ideas ?

Cheers,

[nigelk]

Mtrend

Try this (can also go in the worksheet calculate event).

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

If IsEmpty(Range("a1")) Then
Range("a1").Formula = "=SUM(b1:e1)"
Range("a1") = Range("a1").Value
End If

End Sub

Nigel.

[mtrend]

Thanks Nigel Il give it a go tonight after work & let you know !

Ta

[mtrend]

That works a treat, thanks

Ordered 3 excel books from Amazon so hopefully soon il be able to help some people out