Naming objects

In addition to providing names for cells and ranges, you can give more meaningful names to objects such as pivot tables and shapes. This can make it easier to refer to such objects, especially when you refer to them in your VBA code.

To change the name of a nonrange object, use the Name box, which is located to the left of the formula bar. Just select the object, type the new name in the Name box, and then press Enter.

Note If you simply click elsewhere in your workbook after typing the name in the Name box, the name won't stick. You must press Enter.

For some reason, Excel 2007 does not allow you to use the Name box to rename a chart. You must use Chart Tools Layout1 n Properties' n Chart Name.


0 0

Post a comment