writing a macro which pastes a formula into a cell (r,c)
to equal the value of a cell in another sheet (rr,cc)
then r=r+1, rr=rr+1 and repeat this in a loop count =1,
until count =4 then r=r+1 (still) but rr=rr+4 and count
is reset to count =1

the count bit is no problem but i cant get it to paste
the formula, i believe the vba code to paste the formula
is: ActiveCell.Formula = "=Sheet4!(rr+2,cc+1)"

Please help