Insert text in cell using VBA

[JockW]

Here's an easy one...
What code line can I add to a working macro which will add "some text" to
Sheet1 C2 when run?

 

[karma]

Here's an easy one...
What code line can I add to a working macro which will add "some text" to
Sheet1 C2 when run?

Sub test()
Application.Worksheets("Sheet1").Range("C2") = "test"
End Sub

HTH

 

[JockW]

Thanks Karma
--
tia

Sub test()
Application.Worksheets("Sheet1").Range("C2") = "test"
End Sub

HTH