How do you give a cell a field name?

[max1565]

Could someone please tell me how to give a field name(excel 2000) to a cell. I couldn't find it in help files or through a search of the forum.

Thanks

 

[PHV]

Take a look at this method:
ActiveWorkbook.Names.Add

Hope This Help
PH.

 

[max1565]

Thanks for the quick response PHV. I am sorry I was not clear enough in my question. I am actually trying to do it manualy and not with code.

Thanks

 

[PHV]

You're in VBA forum...
Click in the name ListBox and type your desired name.

Hope This Help
PH.

 

[bluedragon2]

Menu item Insert/Name/Define



[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...