I use this little code here for recalculations on the cells i select. Its works very well.
Public Sub RecalculateSelection()
If TypeName(Selection) = "Range" Then Selection.Calculate
End Sub
what i need to do now is set up a large macro within which i need to re-calculate different cells...