Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Crewman
 
Posts: n/a
Default How do I reference a comment in a formula

I want to have a comment in a workbook and that comment is in turn reference
by many other workbooks. This will avoid having to change many workbooks
instead of just the one. Version being used is Excel 2003
  #2   Report Post  
Myrna Larson
 
Posts: n/a
Default

If you really mean "comment" according to Excel's definition of the term, I
suggest you put your text in a cell instead. Other workbooks can retrieve the
text from that cell. Otherwise you would need a VBA function to retrieve the
comment text, and I don't know off-hand whether such a function can work with
closed workbooks.

On Mon, 24 Jan 2005 19:41:02 -0800, "Crewman"
wrote:

I want to have a comment in a workbook and that comment is in turn reference
by many other workbooks. This will avoid having to change many workbooks
instead of just the one. Version being used is Excel 2003


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
incrementing formula reference by 7 Patti Excel Discussion (Misc queries) 2 January 20th 05 08:23 PM
Need formula for sheet & cell reference MPH Excel Worksheet Functions 0 January 16th 05 03:39 PM
Copying a mixed reference formula Sarah Excel Discussion (Misc queries) 6 January 13th 05 09:45 PM
copying a formula, the reference adjusts, but the result does not chezoo Excel Discussion (Misc queries) 1 January 12th 05 01:51 AM
Formula to reference column heading JimDandy Excel Worksheet Functions 1 November 17th 04 04:06 PM


All times are GMT +1. The time now is 03:39 PM.

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"