View Single Post
Old 08-12-2022, 07:05 PM
soroush.kalantari soroush.kalantari is offline Windows 10 Office 2016
Advanced Beginner
Join Date: Jun 2021
Posts: 47
soroush.kalantari is on a distinguished road

Originally Posted by Debaser View Post
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)
Thank you very much. The issue was solved.
Reply With Quote