http://www.excelfunctions.net/... Operator Action Precedence (1=top; 5=bottom) ^ The power operator 1 * The multiplication operator 2 / The division operator 2 \ The integer division operator - this operator divides two numbers and returns the integer result (eg. 7\4 gives a result of 1) 3 Mod The modulus operator - this operator divides two numbers and returns the remainder (eg. 8 Mod 3 gives a result of 2) 4 + The addition operator 5 - The subtraction operator 5

Private Sub Power() Dim val1 as double; //val1 is x Dim val2 as double; //val2 is n Dim val3 as double; //val3 to store result val3 = val1 ^ val2; //val3 will have the result End Sub

scopsgen, U might want to declare the power as function taking two parameters val1, val2 and returning val3, the code is not of any use if you can not give argument or get value. right?? smileypkr, Why do you need VBA for power, you have power function in Excel right, but if you want to use this in code makes sense, but you can always access inbuil power function using worksheetfunction property such as =Application.WorksheetFunction.Power(x,y)