I want to assign one Max formula in this particular cell (M3)
I tried with this formula MAX(H:H), it is working fine and result is coming well and I recored into macro,
the code I think, ActiveCell.FormulaR1C1 = "=MAX(C[-5])" but whenever I tried to run macro, this result is
displaying some other cell, may be what the cell I selected before running the macro that cell will be
containg the result but I want display this result only on M3, what is the macro code for that ? somebody please help me...
Thanks in advanve.