Hi
maybe something like
sub foo()
dim i
for i = 11 to 99 step 11
cells(i,1).formulaR1C1="=R[0]C[1]*2"
next i
end sub
--
Regards
Frank Kabel
Frankfurt, Germany
"MsAmethyst" schrieb im
Newsbeitrag ...
I know how to do a basic macro. But how would I tell a macro to copy
a
formula to rows 11, 22, 33, and so on in a large spreadsheet?
|