User Defined Function

Frank e,


Can we see the entire UDF that you are working on?

Please Login or Register  to view this content.

Have a great day,
Stan

Hello Frank e,

You can use most of Excel's worksheet functions in VBA. To use them in VBA they are called in a special way using the WorksheetFunction property. Unfortunately the SQRT function is not available in VBA. You have to write your own function, like this...

Please Login or Register  to view this content.

As for the others, like SUM, here is an example...

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Originally Posted by Leith Ross

Hello Frank e,

You can use most of Excel's worksheet functions in VBA. To use them in VBA they are called in a special way using the WorksheetFunction property. Unfortunately the SQRT function is not available in VBA. You have to write your own function, like this...

VBA has its own

Please Login or Register  to view this content.

And yours is a SQUARE function, not SQRT :-)

Thank you for the help. Not being able to use the square root function
will make the large formula even larger. I will use x^0.5.
Thanks again.

Here is a copy of the code I'm using for my UDF.
I am getting a #REF! message in the cell
where I enter, =Add2(cell1,cell2,cell3,cell4).
Any idea's on what I'm doing wrong?
Thanks.

Please Login or Register  to view this content.