Need help detecting the reason for a strange behavior of a UDF

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Need help detecting the reason for a strange behavior of a UDF

#10

08-12-2022, 07:05 PM

soroush.kalantari soroush.kalantari is offline

Windows 10 Need help detecting the reason for a strange behavior of a UDF

Office 2016

Competent Performer

Join Date: Jun 2021

Posts: 124

Quote:

Originally Posted by Debaser

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.

Tags

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Strange behavior with Word macro	Ulodesk	Word	5	06-04-2022 12:40 AM
Strange Behavior with a Graph in Word	RP McIntosh	Drawing and Graphics	6	07-01-2019 08:29 PM
strange search behavior	cyraxote	Word VBA	0	05-05-2017 03:00 PM
Strange macro behavior in 2016	Ulodesk	Word VBA	5	04-02-2017 03:34 PM
Pasting - strange behavior	SatControl	Word	5	02-14-2010 12:57 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:53 PM.