Range Parameters

  • Thread starter Thread starter Bertrand
  • Start date Start date
B

Bertrand

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
 
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
'<<=============
 
Back
Top