Inserting Worksheet Values with a Macro

Summary: Placing values into a cell with a macro is easy when you use the Value property. This tip demonstrates how you can use the Value property in your own macros. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

Inserting values into a cell is done quite often in macros. In order to insert information into a cell, you use the Value property. For instance, you could use the following to insert a number (23) into cell A1:

Cells(1, 1).Value = 23

For entering information in a cell, the Value property is applicable to any object that resolves to a range. Thus, you could use the following to place a text value ("Address") into the cell at C4:

Range("C4").Value = "Address"

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2313) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Save Time! ExcelTips has been published weekly since late 1998. Past issues of ExcelTips are available in convenient ExcelTips archives. Have your own enhanced archive of ExcelTips at your fingertips, available to use at any time!

Check out ExcelTips Archives today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Inserting Worksheet Values with a Macro