Advance in a cell range using VBA
How can I increment/decrement the address function of a cell range. Can I
move back and forward throughout a cell range?
Dim myCell As String
I.E myRange = Range (A1:A5)
For Each myCell in myRange.Cells
myCell.Adress++ (this is incorrect)
Next myCell
Thanks!
|