Youo can create a function for example
Function Test(A, B) As Integer
Test = A * B
End Function
And use in cell A1: "=Test(B1,C1"
If you change B1 or C1, A1 will update
--
Kaak
------------------------------------------------------------------------
Kaak's Profile:
http://www.excelforum.com/member.php...fo&userid=7513
View this thread:
http://www.excelforum.com/showthread...hreadid=557271