Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
looping with formula inside
Dim as as Range, b as Range
Dim x as Long, i as long Set a =worksheets("sheet1").range("a1") set b =worksheets("sheet2").range("a2") x = 10 for i to x a.formula= "= 2*" & b.Address(external:=True) set a=a.offset(0,1) set b=b.offset(0,1) Next -- Regards, Tom Ogilvy a.ekster wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
use CTRL key inside a formula | Excel Worksheet Functions | |||
creating a looping formula between different spreadsheets | New Users to Excel | |||
looping formula - r1c1 problem - Con't | Excel Programming | |||
looping formula - r1c1 problem | Excel Programming | |||
looping Ranking formula - R[1]C[1] | Excel Programming |