Writing Macros in Excel
-----Original Message-----
Am trying to write a Macro that looks at three fields
(cells) and gives me the Minimum, Maximum, and Average
into another specified field, i.e. Cells(i, 7).Value = Min
(Cells(j, 2)(k, 2)). Get error message that Min is an
undefined Sub or Function. How do I calculate the Min?
.
Here is how I ended up making it work...
Range("I" & y).FormulaR1C1 = "=MAX(RC[9]:RC[21])" 'MaxQty
|