Named Range in a Macro

[ozgeek]

I'm hoping someone would be able to assist me.
I have a macro for a costings report I run every month, my problem is that the amount of rows changes each month, so I have a macro to simply select all the rows
Range("A2").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.EntireRow.Select

But I want to name this range so I can do fun things to it later, like sort, filter and subtotal.

How can I name this range?
Thank you

- Using Excel 2007

 

[syntaxed]

Names.Add Name:="YourNameHere", RefersTo:=Selection

 

[ozgeek]

Sorry I forgot to report that your solution works like a charm.
Thank you very much

Dianne