Return Values
The following functions return string datatypes
sRowNumber = Application.WorksheetFunction.Match(Range("B3"), Range("F3:F14"), 0)
?? How to return a value from an array formula
Alternative enter into the cell then just replace it with its value
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext