View Single Post
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

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?