whose2know
Board Regular
- Joined
- May 1, 2002
- Messages
- 59
I have built many macros where I set a loop up to select rows. Since rows are numeric, the statement > Range("A" & Start & ":AQ" & Start).Select < works where Start is the loop counter.
Today I ran into the need to select columns through a loop. I was trying to find how to do it using R1C1 commands, but was unable to. I know about the offset command, but that won't work in my case.
I'd appreciate any help anyone can provide.
Today I ran into the need to select columns through a loop. I was trying to find how to do it using R1C1 commands, but was unable to. I know about the offset command, but that won't work in my case.
I'd appreciate any help anyone can provide.