View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
a.ekster a.ekster is offline
external usenet poster
 
Posts: 1
Default looping with formula inside

i have problem with the following code
could anybody help?thanks in advance
a =worksheets"sheet1".range"a1"
b =worksheets"sheet2"."range a2"
for i to x
a.formula= "= 2*b"
a=offset(0,i)
b=offset(0,i)
alex