Thread
: [Solved]
Need help detecting the reason for a strange behavior of a UDF
View Single Post
08-11-2022, 09:08 AM
Debaser
Windows 7 64bit
Office 2010 32bit
Competent Performer
Join Date: Oct 2015
Location: UK
Posts: 221
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)
Debaser
View Public Profile
Find all posts by Debaser