VBA to select last row

[lday75]

I am trying to select all cells in cols A-K LASTROW ONLY and I keep running into Method of Range errors. Can some one please point to where my mistake is with the Range.Select statement?

Thank You

Please Login or Register  to view this content.

[mike7952]

This should do it

Please Login or Register  to view this content.

[lday75]

Mike,

thank you, but that selects ALL cells to the last row in Col K. I only need the cells in the last row.

For example if last row is 18, would be A18-K18, but I cannot seem to get it by using lastrow.

I need to use lastrow (dynamic rather than static) is because the procedure this is in gets run against several sheets and each one has a different amount of records on it.

[mike7952]

Then this will work

Please Login or Register  to view this content.

[lday75]

Sweet, thank you, and I see where I was missing it with my several itterations and attemtps!!

Here is what I had that did not work, I was close !! lol

Please Login or Register  to view this content.

Damned quotes get me all the time!

Thanks again for this, i appreciate it.

[mike7952]

This would be better and proper

Please Login or Register  to view this content.