SetSheetValue

concerns

The SetSheetValue attribute function sets a value in a specific cell.

 

Syntax

SetSheetValue(Value As Variant, ExcelAddress As String)

Return value

None

Parameter

Use

Name

Type

Passing

Description

Required

Value

Variant

ByVal

Cell value

Required

ExcelAddress

String

ByVal

Excel cell description

 

Example

 

Dim Value As Variant

Value := 10

Sheet.SetSheetValue(Value, "B1")