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
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
Last edited by rvc81; 08-30-2012 at 03:10 AM.
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
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Star below the post.3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Activecell can't be used in a UDF, use Application.Caller as in "DataRow = Application.Caller.Row"
thanks bongaan: changed activecell.row to Application.Caller.row work perfectly fine now. thanks again
Leith Ross: thanks for the link.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks