How to: Send Values to Worksheet Cells

Applies to

The information in this topic applies only to the specified Visual Studio Tools for Office projects and versions of Microsoft Office.

Project type

  • Document-level projects

  • Application-level projects

Microsoft Office version

  • Excel 2003

  • Excel 2007

For more information, see Features Available by Application and Project Type.

You can put a value in a cell by using a range. The following examples use the Value2 property of the range instead of the Value property to avoid having to pass in parameters.

To send a value to a cell in a document-level customization

  • Create a NamedRange control on cell A1 of Sheet1, and assign a string value to the Value2 property. Place the following code in the Sheet1 class.

    Dim nr As Microsoft.Office.Tools.Excel.NamedRange = _
        Me.Controls.AddNamedRange(Me.Range("A1"), "NamedRange1")
    nr.Value2 = "Hello World"
    Microsoft.Office.Tools.Excel.NamedRange nr =
        this.Controls.AddNamedRange(this.Range["A1", missing], "NamedRange1");
    nr.Value2 = "Hello World";

To send a value to a cell in an application-level add-in

  • Create a Range that represents cell A1 of Sheet1, and assign a string value to the Value2 property.

    Dim rng As Excel.Range = Me.Application.Range("A1")
    rng.Value2 = "Hello World"
    Excel.Range rng = this.Application.get_Range("A1", missing);
    rng.Value2 = "Hello World";

Robust Programming

The following condition causes an exception:

  • The worksheet exists and is read-only (COMException class).


User input can include information that is potentially malformed, malicious, or not valid. Always check that the values that a user enters conform to the requirements for your application before using the values. For more information, see User Input Validation in Windows Forms.

See Also


How to: Refer to Worksheet Ranges in Code

How to: Add New Worksheets to Workbooks


Working with Cells

NamedRange Control

Host Items and Host Controls Overview

The Variable missing and Optional Parameters in Office Solutions

Change History




July 2008

Added a code example that can be used in an application-level add-in.

Customer feedback.