I have this problem which is really killing me. I have built a spreadsheet using some UDF. In the UDF, I use a with/end with, and when using the with statement, i specified the with workbooks(" ").worksheets("")
When I tried to link the values (calculated by this UDF) to another spreadsheet, everything works. But when my manager tries it on his pc,
he always got the $values everytime.
I really dont understand why it works on my pc but not his. And I'm taking
the blame along the process
Any help is appreciated!