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
Posts: 197
Debaser will become famous soon enough

Your issue is here:

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