Select column using cells

[Forestq]

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....

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

next i

 

[Special-K99]

etc ?????

When do you want the loop to stop ?

 

[Forestq]

I have already did it:

ws.Range(Cells(2, i), Cells(last_rowx, i)).Select