How to select the full last column of the last row in VBA?

[Bassie]

Hey,

So I know how to select last rows and last columns seperatly but I cant figure out for the life of me how to combine the two. I am trying to first find the last column and then use the & Rows.Count).End(xlUP)) to find the last row aswell and exlude the header aswell if possible.

 

[mohadin]

lr = Cells(Rows.Count, Cells(7, Columns.Count).End(xlToLeft).Column).End(xlUp).Row

 

[Bassie]

lr = Cells(Rows.Count, Cells(7, Columns.Count).End(xlToLeft).Column).End(xlUp).Row

Thank you! I am a bit new to VBA and it seems that it works but how do I select these cells now?

 

[mohadin]

lc = Cells(7, Columns.Count).End(xlToLeft).Column
lr = Cells(Rows.Count, Cells(7, Columns.Count).End(xlToLeft).Column).End(xlUp).Row

Cells(lr, lc).Select