Udf resets on 3rd workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm stumped and would greatly appreciate the input of anyone who can offer it.

I've encountered a very odd bug in a workbook with UDF macros in it. I find
that if I open 2 blank workbooks then another one which has similar macros it
causes the first workbook to change the cell results to #value.

I would greatly appreciate any input on why this could be occuring.

Thanks

Denis
 
Does any of your UDF code access ranges directly, ranges that are not passed
in as parameters? Anything in the code with ActiveSheet or ActiveWorkbook?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

UDF XLA and SQL queries 1
User Defined Function being called by changes to an independent workbook 13
UDF Last Save Date returning 3 different results 1
UDF not returning proper value - circular reference/multi workbook 1
Is Workbook open without error 3
Run a code on a workbook? 2
UDF interaction with other macro causes Error 1004 6
Schedule a macro on a specific time 4

Back
Top