Value! Error in UDF

[acawai]

I'm new to VBA and am having trouble with this function. My goal is to find the difference between the sums of the cells in two ranges (sourceDR and sourceCR) which match a value (given in match) in a criterion range (subset).

Please Login or Register  to view this content.

The function is returning #Value! when I attempt to evaluate it in a worksheet. For example, if the data ranges are b1:b4 and c1:c4, the criterion range is a1:a4, and the value to be matched is in a6, I enter

Please Login or Register  to view this content.

into b6 and get #Value!. If I omit the sourceCR argument (c1:c4), the function correctly returns the sum of b1:b4 for which the criterion in a1:a4 matches a6.

Thanks for your help.

[TMS]

Works for me. Suspect it's your data.

Please Login or Register  to view this content.

You probably need to post a sample workbook that demonstrates the problem.


Regards, TMS

[acawai]

Yes, you're right. I copied all of my data into a new workbook, and now the function runs properly. Thanks!

[TMS]

You're welcome. Thanks for the rep.