Mark usage range by vba

[Panoos64]

Hi to everyone, i would be greatly appreciate if you could help so that to create a vba code and mark the usage range in excel. Please note that the rows are change each time whenever i download the data. Below is an example in col. "A", "B", "C" till row "8". Many thanks in advance

A B C

Daily Rate	Reservations	Sales
102.00	19	1938
68.00	18	1224
73.00	101	7373
77.00	17	1309
85.00	45	3825
96.00	15	1440
65.00	10	650

<colgroup><col style="mso-width-source:userset;mso-width-alt:3328;width:68pt" width="91"> <col style="mso-width-source:userset;mso-width-alt:3291;width:68pt" width="90"> <col style="mso-width-source:userset;mso-width-alt:2998;width:62pt" width="82"> </colgroup><tbody>
</tbody>

 

[JackDanIce]

Try:

Sub SelectRange

Dim LR as Long

LR = Cells(Rows.Count, 1).End(xlUp).Row
Cells(1,1).resize(LR, 3).Select

End Sub

 

[Panoos64]

Hi Jack, thank you so much for the help and your support. It works perfect and nicely! Have a great day!

 

[JackDanIce]

You're welcome