Select Dynamic Range

[rodrigo_m_almeida]

Good afternoon people
Does anyone have any ideas
How to select to the last row and column
without defining

I need to select this area...
I just won't know how many columns and rows I'll have
I'm using

Range("B2:O" & Range("A1").End(xlDown).Row).Select

How can I adapt this code to also select the last column, just like the line, without having to declare ???

 

[DanteAmor]

Try this:

  Range("B2", Cells(Range("A" & Rows.Count).End(3).Row, Cells(1, Columns.Count).End(1).Column)).Select

 

[rodrigo_m_almeida]

Try this:

  Range("B2", Cells(Range("A" & Rows.Count).End(3).Row, Cells(1, Columns.Count).End(1).Column)).Select

Solved my problem, thank you very much!!!
I didn't know what else to do...
Hahaha