The formula I need to use is an XLookup(Max format, however it doesn't translate to my application.XLookup function in VBA.
I have tried this:
However, it is saying the MAX sub is undefined. Is there a different function or application I should be using?
Please Login or Register to view this content.
Crossposted at stackoverflow.com/questions/76096591/how-do-i-translate-my-xlookup-max-formula-to-vba
Max is not a VBA function. Use Application.WorksheetFunction.Max. You should also use Application.WorksheetFunction.XLookup.
I think your parentheses may not be correct. Xlookup requires three arguments and you have only given it one. Everything in Xlookup is inside the Max function. Look at it like this:
I can't fix it because I don't know what you want it to do.Please Login or Register to view this content.
Last edited by 6StringJazzer; 04-24-2023 at 07:49 PM.
is the lookup value.Please Login or Register to view this content.
is the lookup array.Please Login or Register to view this content.
is the return array that I want the max value from. Does that make sense?Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks