Visual Basic Syntax
That works ... Thx Much!
-----Original Message-----
MyRange.Offset(1)
MyRange.Offset(2)
....etc
Hth,
Tim
"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?
.
|