Multiplying in excel through vba -

Multiplying in excel through vba -

i new vba programming, want create programme "how re-create n number of columns , rows 1 excel sheet , multiply values given constant number"

consider, model:

sub demo() dim r1 range, r2 range, c double c = 0.123 set r1 = sheets("sheet1").range("a1:b9") set r2 = sheets("sheet2").range("a1:b9") r1.copy r2 each r in r2 r.value = c * r.value next r end sub

excel vba