Variable Contents Into Cell

[Himszy]

Hi

How do you insert the contents of a variable into a cell?

Thanks Michael

 

[Himszy]

Hi

How do you insert the contents of a variable into a cell?

Thanks Michael

Also, how do you save the contents of a cell to a variable

 

[Nick Hodge]

Michael

Comment lines are preceded with '

Sub DemoVariable()
'Dimensions two variables
Dim sName1 As String, sName2 As String
'Assigns one a string value
sName1 = "Nick Hodge"
'Passes that string value to the
'range A1 on active sheet
Range("A1").Value = sName1
'Picks up a value from A2 on active sheet
'and assigns to 2nd variable
sName2 = Range("A2").Value
'Displays message box with 2nd variable value
MsgBox sName2
End Sub

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[Himszy]

Michael

Comment lines are preceded with '

Sub DemoVariable()
'Dimensions two variables
Dim sName1 As String, sName2 As String
'Assigns one a string value
sName1 = "Nick Hodge"
'Passes that string value to the
'range A1 on active sheet
Range("A1").Value = sName1
'Picks up a value from A2 on active sheet
'and assigns to 2nd variable
sName2 = Range("A2").Value
'Displays message box with 2nd variable value
MsgBox sName2
End Sub

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

Thanks Nick