M
Mallick
Hi Every One
I am relatively new to programming and have benefited greatly from this
forum. I have got another very basic issue which I am unable to address
myself.
I am comparing the smallest value from an array which is stored in variable
"Least" and then, look for the corresponding value in another array with the
following code:
Least = Application.WorksheetFunction.Small(Array, 1)
A = Application.WorksheetFunction.HLookup(Least, Range, 6, False)
I would also like to obtain the cell addresses of the two (The smallest of
"Array" and its correspodning value in "Range".
Kindly help.
Many Thanks
Mallick
I am relatively new to programming and have benefited greatly from this
forum. I have got another very basic issue which I am unable to address
myself.
I am comparing the smallest value from an array which is stored in variable
"Least" and then, look for the corresponding value in another array with the
following code:
Least = Application.WorksheetFunction.Small(Array, 1)
A = Application.WorksheetFunction.HLookup(Least, Range, 6, False)
I would also like to obtain the cell addresses of the two (The smallest of
"Array" and its correspodning value in "Range".
Kindly help.
Many Thanks
Mallick