udf error

  1. mikecox39

    UDF question: from Chapter 4 VBA and Macros text.

    I'm studying Jelen's book "VBA and Macros" and at the start of Chapter 4, on UDF's, he directs the reader to open a new module in the the VBA Editor and type the following function into the module: Add (Number1,Number2). Can someone tell me what I'm doing wrong because when I enter that line I...
  2. S

    VBA for UDF to add to data range vs table?

    Hi, I just recently started using VBA and discovered this community. looking forward to picking up new tricks. I have built a user form for adding attendance to events using comboboxes to prevent errors. i'm using vlookups in 2 columns for calculating payments to attendees. having difficulties...
  3. M

    Convert Subroutine to a UDF - Range Issue

    I have a Subroutine that works just fine, but I have had a request to make it a UDF I thought it would be easy there are just two variables one is a range and the other a single cell, but the range doesn't appear to translate as expected - debugging produces an "Application-defined or...
  4. B

    UDF calculates but when switching workbooks gives #ref error

    Hi, I am having problems with a UDF I found. This sums values across different sheets (the ones you pick) in the workbook. The problem I am having is that when I do a full calc the function works but if i open a new workbook or worksheet I get a #ref error. I need to reference this in another...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top