View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
JockW JockW is offline
external usenet poster
 
Posts: 32
Default 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