hi there,

i want to make a macro that takes the sum of cell (B1) for example and
multiplies it by (A1), my problem is that i also want to apply the macro on
other cells (like (B2)) so i want to have 2 active cells (one for taking sum
of cells & the other to calculate the multiplication) - is it possible?

e.g.
A B C
1 2+3*5 MACRO OF SUM A1*B1
2 7+3*1 MACRO OF SUM A2*B2
3 6+5*2 MACRO OF SUM A3*B3

is it possible?

thank u