Insert text in cell using VBA
 

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?
--
tia

Insert text in cell using VBA
 

On Apr 23, 4:50*pm, JockW wrote:
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?
--
tia

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

HTH

Insert text in cell using VBA
 

Thanks Karma
--
tia


"karma" wrote:

On Apr 23, 4:50 pm, JockW wrote:
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?
--
tia

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

HTH