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