Forestq

Active Member
Joined
May 9, 2010
Messages
482
Hi,

I have loop, where I want to select column starting from AF till to AQ:
AF2:AF100
then AG2:AG100
then AH2:AH100 etc....

Code:
....
For i=32 to 43
  last_rowx = ws.Cells(Rows.Count, "A").End(xlUp).Row
   
     ws.cells(i,2)...???

next i
 

Some videos you may like

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

Forestq

Active Member
Joined
May 9, 2010
Messages
482
I have already did it:

Rich (BB code):
ws.Range(Cells(2, i), Cells(last_rowx, i)).Select
 

Watch MrExcel Video

Forum statistics

Threads
1,118,168
Messages
5,570,615
Members
412,333
Latest member
hectamuptra
Top