Select last row last col

[Emm]

Hi All,

I'm trying to select a range from B5: to last row : last column..
I can do it from B5 to a set column & last row...
But cant seem to get the varible on both row & col...

I am using this at present, but finding it misses if something down low in list with gaps:

Range(Selection, Selection.End(xlDown)).Select
Range(Selection, Selection.End(xlToRight)).Select

am trying this ...

LastRow = Range("B65536").End(xlUp).Row
LastCol = Range("IV5").End(xlLeft).Column
Range("B5" & LastCol & LastRow).Select
but has errors...

all help appreciated

thanks,

Keith

 

[Emm]

Thanks all...

It works because row 5 is my header row...... no data will be inserted if the col dosen't have a header...
and also Col B is my Item ID col ... so nothing will be entered without first putting the ID in...

works great
Picks up very last row of col B & last used Col in my header Row:5 from B onwards .. rather than IV backwards...

LastRow = Range("B" & Rows.Count).End(xlUp).Row
LastCol = Range("B5").End(xlToRight).Column
Range("B5", Cells(LastRow, LastCol)).Select



Thanks..

Keith

 

[Michael M]

Keith
IS there a risk, that at some point, there may be an empty cell in Row 5
If so, (xltoRight) will cause issues rather than using (xlToLeft)
(xltoLeft) is safer because it WILL find the correct Last Col