Quote:
Originally Posted by Debaser
Your issue is here:
Code:
vlookupUDF = Cells(nrow, ncollumn)
that will return the value from whichever sheet is active when the formula calculates. You should use interval.worksheet.cells(nrow, ncollumn) |
Ah yes, well spotted.
Code:
vlookupUDF = interval.parent.Cells(nrow, ncollumn)
should do it (untested).
edit:
just noticed you used
interval.worksheet.cells ; I've never seen that, going to try it now.