Select Range with Last Cell in Column with Data

[HELP PLEASE]

I need a code that will select a range of cells...from cell A2 to the last cell with data in column AZ.

Thanks a lot.

 

[texasalynn]

you can do it with this

Dim LR as Long
LR = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row
Range("A2:AZ"& LR).Select

althought you do not need to generally select data, you would want to do something with the range, like copy
Range("A2:AZ" & LR).Copy

 

[HELP PLEASE]

Could the above code select the last cell in column AZ specifically?

 

[texasalynn]

you just want that cell only?

Range("AZ"& LR).Select

this will select only that cell

oh and also this code deteremines the last cell as laid out by the first column
LR = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row

so if column A is not the best column, change the ", 1" to the column that works best for you.

 

[HELP PLEASE]

Okay...perfect! Thanks!