Hi,
If i have a range called "Range1", How can i say the following:
-find the cell in range1 that has the max value within that range
-and then do a process (which i have already done) for the columns directly to the left of that cell.
would it be something like:
dim num as double
num= worksheefunction.Max(range1)
??
If i have a range called "Range1", How can i say the following:
-find the cell in range1 that has the max value within that range
-and then do a process (which i have already done) for the columns directly to the left of that cell.
would it be something like:
dim num as double
num= worksheefunction.Max(range1)
??