Microsoft Office Forums - View Single Post - [Solved] Need help detecting the reason for a strange behavior of a UDF

Thread: [Solved] Need help detecting the reason for a strange behavior of a UDF

View Single Post

Old

08-12-2022, 07:05 PM

soroush.kalantari soroush.kalantari is offline

soroush.kalantari is offline

soroush.kalantari uses Windows 10

Windows 10 soroush.kalantari uses Office 2016

soroush.kalantari uses Office 2016

Office 2016

Competent Performer

The original poster

Join Date: Jun 2021

Posts: 115

soroush.kalantari is on a distinguished road

Default

Quote:

Originally Posted by Debaser

View Post

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)

Thank you very much. The issue was solved.

Reply With Quote