VBA String Needed to Select Range

[jbmerrel]

I need the VBA string that will do the following:

Find the last used cell in Column M
Go to the Cell in Column A of that row
Select Range from that cell to cell in Column X

Example:
If the last used cell in column M is "M136"
Range("A136:X136").Select

Thanks In Advance,

JBMERREL

[SteveG]

Hi,
Try this:
Sub FindRng()
LastRow = Range("M" & Rows.Count).End(xlUp).Row
Range("A" & LastRow & ":X" & LastRow).Select
End Sub

HTH,

Steve

[jbmerrel]

Your the best Steve. Thanks A million!!!

[Pauleyb]

Something a little different:

range("M" & rows.Count).End(xlUp).offset(0,-12).Resize(1,24).Select

Pauley