Name range between two named cells in VBA Excel 2007

[kimBQT7]

Hello,

The two endpoints of my range are named as "pricing" and "taxes." They refer to two cells that are named in column B in my spreadsheet.

I want to know how to set a range (in a VBA macro) that selects all data in the column between "pricing" and "taxes."

I have Excel 2007.

Does anyone know how to do this?

 

[p45cal]

If you want the end cells to be included:
range(range("pricing"),range("taxes")).name = "rangebetween"

If you don't and pricing is above taxes then:
range(range("pricing").Offset(1),range("taxes").Offset(-1)).name = "rangebetween2"

 

[kimBQT7]

Thanks!