Macro to select last 5 populated rows starting at column B

[obiwann]

I would like to have a macro that will select the last 5 populated rows and select starting at column b.
Ex: Range("B6:P10").
Is this possible?
Any help would be much appreciated.

 

[Fluff]

How about

Sub obiwan()
   Range("B" & Rows.Count).End(xlUp).Offset(-4).Resize(5, 15).Select
End Sub

 

[obiwann]

How about

Sub obiwan()
   Range("B" & Rows.Count).End(xlUp).Offset(-4).Resize(5, 15).Select
End Sub

That works perfect! Thank you.
I have another question, is there code that will select the last 24 used cells in column "A"?

 

[Fluff]

Yup

   Range("A" & Rows.Count).End(xlUp).Offset(-23).Resize(24).Select

 

[obiwann]

Wow that works perfect.
Thanks!

 

[Fluff]

You're welcome thanks for the feedback.

 

[obiwann]

Yup

   Range("A" & Rows.Count).End(xlUp).Offset(-23).Resize(24).Select

How would I code it if I want to select columns A,B & C?

 

[Fluff]

Like

   Range("A" & Rows.Count).End(xlUp).Offset(-23).Resize(24,3).Select