new to excel and VBA and would like to make a function that calculates the average of a row.
Thanks in advance
new to excel and VBA and would like to make a function that calculates the average of a row.
Thanks in advance
Why would you want VBA to this? Excel's inbuilt Functions such as AVERAGE will be more efficient than any VBAQ!
Why would you want VBA to this? Excel's inbuilt Functions such as AVERAGE will be more efficient than any VBAQ!
Yes, I know. Its quite futile but my professor wants us to do it in VBA.
I would be tempted to tell him he needs lessons in Excel and VBA!
Look at Application.WorkSheetFunction
Don’t have an account yet? Register yourself now and be a part of our community!