VBA

Hi Rafia

I guess you want to know if you can create some code that automatically does a calculation without showing the user how it was done

For this I suggest creating a Function. To do this:

In a Module write

Public Function MyFunctionName (Val1 As <Type>, Val2 As <Type>, etc) As <Type>

MyFunctionName = <<The calculation required>>

End Function

Then use the function as any other function in your workbook.

Hope this helps

Carlos