Posted by: shivanagar September 29, 2009
Login in to Rate this Post:
0
?
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)
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)