Visual Basic Syntax
Thx Kevin
You were able to point me in the right direction with the
'("A" & iCounter & ":H" & iCounter)' thing. That answered
half of my next post. To follow thru with the rest. What
would the syntax be if I wanted to add an integer value to
the value of iCounter?
sorta like this w/ wrong syntax:
Range("A" & iCounter+43 & ":H" & iCounter+43)
-----Original Message-----
Hi Al,
Tried this, and it appears to work. This is one solution.
Sub Test()
Dim MyRange As Range
Dim iCounter As Integer
For iCounter = 1 To 10
Set MyRange = Worksheets("Sheet1").Range("A" &
iCounter & ":H" &
iCounter)
MyRange.Value = iCounter
Next iCounter
End Sub
Regards,
Kevin
"Al" wrote in message
...
Dim MyRange As Range
Set MyRange = Worksheets("Sheet1").Range("A1:H1")
Question:
How can I increment MyRange so that when it's in a loop,
it becomes "A2:H2", then "A3:H3" the next time thru,
etc,
etc?
.
|