User Defined Function Opens Improperly - Round II

  • Thread starter Thread starter SteveM
  • Start date Start date
S

SteveM

(This a repost to bubble the query back to the top. Still seeking a
solution.)

I wrote a couple of functions with data links to a second workbook.

The data workbook is already open when I open the workbook with the
functions. However the cells containing the functions open up the
"####" error designator, not the function return value. When I open
the function dialog box attached to a cell, I can see that it
calculates properly and the return value is correct. And I can repair
the problem by simply closing the dialog box by clicking OK.

Any ideas on how to prevent the fault from appearing at all?

Thanks Much,

SteveM
 
A string of #### generally indicates a column being to narrow to display its
contents. Also a 'negative' date can give this effect. What datatype does
your function compute?
Does widening the cell make any difference?
best wishes
 
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

User Defined Function Opens Improperly 3
User Defined Function Opens Improperly - Round III 2
User Defined Function being called by changes to an independent workbook 13
user defined function which increase consecutively while passingbelow cells 12
Application.Caller calls from ActiveWorkbook not the actual cell workbook 1
COM addin won't connect when workbook opened via another workbookfrom another instance 3
User Defined Function 5
User defined function 5

Back
Top