Dynamic Range Name

[Jtucker10278]

Looking to tie the range name to cell value

For example

	A	B	C
1
2		A_Sanchez
3		1
4		3
5		7
6		6
7		2
8		1
9

<tbody>
</tbody>

I want the name of Range B1:B8 to equal the value of B:2

This way when I Fire A_Sanchez and Hire someone else I can put their name in B:2 without having to rename the range

Thanks

 

[alansidman]

http://www.datawright.com.au/excel_resources/excel_range_names_vba.htm