Norman K via OfficeKB.com

Posts: n/a

Thanks !!! JE

JE McGimpsey wrote:
You could use a User Defined Function:

Public Function GetComment(Target As Excel.Range) As String
On Error Resume Next
GetComment = Target(1).Comment.Text
On Error GoTo 0
End Function

Use as

A2: =GetComment(A1)

If you're not familiar with UDFs see

http://www.mvps.org/dmcritchie/excel/getstarted.htm

Hi

[quoted text clipped - 9 lines]

Norman

--
Message posted via http://www.officekb.com

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Cell color based upon cell value	My View	Excel Discussion (Misc queries)	11	July 6th 05 03:59 AM
Can I reference comments by Cell Name?	flo1730	Excel Discussion (Misc queries)	5	June 15th 05 03:34 PM
cell comments	rick N	Excel Worksheet Functions	1	February 11th 05 09:02 AM
Making comments apply to more than one cell	Evelyn	Excel Discussion (Misc queries)	2	February 9th 05 12:08 AM
Can you conditional format based on information in cell comments?	Jflyer	Excel Worksheet Functions	1	January 15th 05 01:52 AM

All times are GMT +1. The time now is 05:29 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us