LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 852
Default Code to add a comment and the text from a sheet range

I can easily write code to add a comment to cell C1, with the comment text hard coded.

I am hung up on how to add text to the comment where that text is a variable list of names in cells Range("P2", Range("P2").End(xlDown)).

Also, the text in the comment to be a single name per line.

Thanks,
Howard
 
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
Add comment with author and text code. L. Howard Excel Programming 6 April 28th 15 07:05 PM
range.comment.Text(...) [email protected] Excel Programming 3 November 6th 07 02:36 AM
code to copy a range of cells to another sheet Robb27 Excel Programming 7 April 4th 06 11:24 AM
setting comment text from VB code Brad Sumner Excel Programming 3 March 24th 06 01:15 AM
Range's comment text Mircea Pleteriu Excel Programming 0 January 20th 05 10:36 AM


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

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

About Us

"It's about Microsoft Excel"