9. To name a cell or range in Excel 2003 macro

Naming a cell or range would be petrified at the time of ita for applications, such as the user name of the range in the Data Validation feature. Here are some of the cell naming rules:

• Cell name must start from the letter (not a character or numeric).
• Name the cell that consists of two or more words should not be separated by a space. You can use your underscore (_) to replace the spaces. For example, the cell name price goods can be altered by Harga_Barang.
• In a workbook, the cell name must be unique (no name the same cell in a workbook).