in macro code cell A1 is cells(1,1)

cell B5 is cells(5,2)

so you need to write a simple macro along the lines of

for j=1 to 1100 step 10
cells(j,1)="A"
next j
end

if your data to be inserted is in a list in column Z try

for j=1 to 1100 step 10
sum=sum+1
cells(j,1)=cells(sum,26)
next j
end


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=558410