XL2002
In a For ...If loop I want the range to change according to the value of
the loop, but how?

For example

For cy = 1 to 70
Range("E cy") = 'something'
Next cy

In other words :- put 'something' in E1 and then E2 etc. up to E70

How do I get the "text" in the Range instruction to change with each
variation of *cy*?



[hope I've explained this OK]

Many Thanks
Bertrand