I’m trying to come up with a macro that will divide the values in a cell range (of an active cell row), by the value of the active cell.
In other words: A1 = 4 (active cell), A2=8 and A3=16. The result would be A2=2 and A3=4. I would select the first cell in any given row, and then run the macro.
Thanks in advance, Steve
In other words: A1 = 4 (active cell), A2=8 and A3=16. The result would be A2=2 and A3=4. I would select the first cell in any given row, and then run the macro.
Thanks in advance, Steve