Databases
StackOverflow2013
Postsdbo
POFailure to Pass Arguments to a UDF in VBA for Excel 2007
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POFailure to Pass Arguments to a UDF in VBA for Excel 2007
    primarykey
    data
    text
    <p>I have a complex iterative spreadsheet in which I want to use a UDF to calculate the heat transfer coefficient of a heat exchanger. The function has 5 arguments (2 strings and 3 doubles). The strings and 1 double pass just fine. The remaining two don't seem to go through at all. A watch on problematic arguments shows them to be equal to zero. I tried redefining the arguments as variants, and then I can find the value I want in the "value2" field. However, as soon as I try to access it (via varName.Value2) it disappears (the watch suddenly lists the field as "Empty").</p> <p>The cells passed into the function for the problematic arguments are heavily dependent on the rest of the spreadsheet, and their value changes almost every iteration.</p> <p>Has anyone seen this before and know of a workaround?</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POFailure to Pass Arguments to a UDF in VBA for Excel 2007
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POFailure to Pass Arguments to a UDF in VBA for Excel 2007
      1. USHK_CH
      1. VTFavorite
    3. VO
      singulars
      1. POFailure to Pass Arguments to a UDF in VBA for Excel 2007
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload