Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 32
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
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
  #3   Report Post  
Posted to microsoft.public.excel.programming
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert value from another cell AND text [email protected] Excel Worksheet Functions 3 June 28th 07 07:47 PM
Need a macro to insert text in a cell that already has text.Excel go1angel Excel Discussion (Misc queries) 2 October 5th 05 10:32 PM
Need a macro to insert text in a cell that already has text.Excel go1angel Excel Programming 1 October 4th 05 06:54 PM
Insert Text From Different Cell Joradi New Users to Excel 3 September 1st 05 04:47 PM
Insert cell/format/text/fontsize and auto insert into header? Unfurltheflag Excel Programming 2 November 3rd 04 05:39 PM


All times are GMT +1. The time now is 11:03 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"