B
Brettjg
Within a macro I want to go to the next cell across. I know I can do it by
using offset, but is there a way I can just increment "A" to "B" in the same
way that I can increment down a row from 1 to 2 by using 1 + 1?
e.g. I can go a cell down by using:
Range("A" & Counter).Select
Counter = Counter + 1
Range("A" & Counter).Select
but how do I use similar code to increment across (or back)? I want to use
this in a loop for a variable cell prefix.
Thanks & Regards, Brett
using offset, but is there a way I can just increment "A" to "B" in the same
way that I can increment down a row from 1 to 2 by using 1 + 1?
e.g. I can go a cell down by using:
Range("A" & Counter).Select
Counter = Counter + 1
Range("A" & Counter).Select
but how do I use similar code to increment across (or back)? I want to use
this in a loop for a variable cell prefix.
Thanks & Regards, Brett