jmenche
05-26-2011, 09:15 AM
Folks,
I want to write a routine that loops through rows. Every time through the loop, I want to select range C through G with whatever row i'm on. I've done this with only one with success ("C5:G" & lastcolumn, e.g.). I cannot find the magic syntax for two.
Here is what I am trying to do. If i is my row counter, how can I select range("C" & i & ":G" & i)?? I cannot figger out how to throw the colon in there.
Thanks
:beerchug:
I want to write a routine that loops through rows. Every time through the loop, I want to select range C through G with whatever row i'm on. I've done this with only one with success ("C5:G" & lastcolumn, e.g.). I cannot find the magic syntax for two.
Here is what I am trying to do. If i is my row counter, how can I select range("C" & i & ":G" & i)?? I cannot figger out how to throw the colon in there.
Thanks
:beerchug: