i have this function inserted into a workbook to convert dollar amounts to words, however when i send the workbook the recipient's workbook will not work, returns =name! after the currency value is the reference cell is changed. any idea what could cause this?
richard
probably an add in you have it they dont or havent enabled it what is the function you are using?
your profile shows xl2003 have you changed to 2007? it could be you aren't saving as xlsm and there is a udf in your workbook
Last edited by martindwilson; 02-09-2010 at 06:49 AM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
recipient just had to enable macro and then it worked, thanks for the info
richard
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks