Help: Loop code in excel

[Walshie1987]

Hi, I am wanting to do the following, how would I put it into code please?

if cell a1 = (few calculations) then
cell b1 = Y
else
b2 = N

then I want to move onto cell a2 and run the same formula e.g

if cell a2 = (few calculations) then
cell b2 = Y
else
b2 = N

but have to run the calculations on about 1000 cells and dont want to type the above out 1000 time (or copy and paste)

Surely there is a loop / step command?

Cheers
Chris

 

[ck1999]

for vrow = 1 to 1000
if cells(1,a).value = then

next vrow
and go from there


ck1999

 

[ck1999]

should of been

if cells (vrow,a).value then

 

[SkipVought]

ck,

a is used as a variable and is UNDEFINED.

a = 1
...
if cells (vrow,a).value then

or...

if cells (vrow,"A").value then

Skip,

_{Did you hear what happened when the OO programmer lost his library?...
He's now living in OBJECT poverty!}

 

[Walshie1987]

Perfect! Thanks alot