My worksheet contains several columns of numerical data. I have written a macro that finds the maximum and minimum values of a designated column. How can I also find the row numbers associated with these values?
My worksheet contains several columns of numerical data. I have written a macro that finds the maximum and minimum values of a designated column. How can I also find the row numbers associated with these values?
try this file