when i enter a value in any cell of Range A2:A6 and B2:B6 then out put (multiplication of Range A2:A6 and B2:B6) will be shown in C2:C6
i do this only by worksheet selection change event by macro ex.
when i input value in "A2" and "B2" then out put show in "C2" or when i enter any value in "A3" and "B3" then output show in "C3". then respectively other cell.