User Defined Function does not the give the correct result

[rvc81]

hi,

I need some help with my UD function code - not able to figure out what is wrong with the code. (file attached)

Thanks
R

[Leith Ross]

Hello rvc81,

There are many restrictions when using UDFs. Here is an excellent link that explains what you can and can not do with a UDF.

Excel User Defined Functions

[bongaan]

Activecell can't be used in a UDF, use Application.Caller as in "DataRow = Application.Caller.Row"

[rvc81]

thanks bongaan: changed activecell.row to Application.Caller.row work perfectly fine now. thanks again

Leith Ross: thanks for the link.