Range Parameters
 

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

Range Parameters
 

Hi Bertand,

Perhaps, try something like:

'=============
Public Sub Tester()
Dim cy As Long

For cy = 1 To 70
Range("E" & cy) = "ABC" & cy
Next cy

End Sub
'<<=============


---
Regards,
Norman


"Bertrand" wrote in message
...
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