How to: Send Values to Worksheet Cells

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).

Security

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

Tasks

How to: Refer to Worksheet Ranges in Code

How to: Add New Worksheets to Workbooks

Concepts

Working with Cells

NamedRange Control

Host Items and Host Controls Overview

The Variable missing and Optional Parameters in Office Solutions

Change History