S
SeanF74
I have a list of 10,000 lines of data starting from row 2 in Excel 2007. I
would like to select a range of cells from each line individually (columns C
through L) for each of the 10k lines and sort horizontally. I am trying to
use a do loop to do this, but I cannot set the range correctly with a
variable (say c) to create a dynamic range. Here is a simplified view of
what I have:
c = 2
Do While c < 15000
Range("C2:L2").Select
c = c +1
Loop
What syntax do I use in the Range.Select argument using the c variable to
move down a line each time I run through the Do Loop?
Thanks,
would like to select a range of cells from each line individually (columns C
through L) for each of the 10k lines and sort horizontally. I am trying to
use a do loop to do this, but I cannot set the range correctly with a
variable (say c) to create a dynamic range. Here is a simplified view of
what I have:
c = 2
Do While c < 15000
Range("C2:L2").Select
c = c +1
Loop
What syntax do I use in the Range.Select argument using the c variable to
move down a line each time I run through the Do Loop?
Thanks,