View Single Post
 
Old 08-11-2022, 09:08 AM
Debaser's Avatar
Debaser Debaser is offline Windows 7 64bit Office 2010 32bit
Competent Performer
 
Join Date: Oct 2015
Location: UK
Posts: 221
Debaser will become famous soon enough
Default

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)
Reply With Quote