Thread: Copying text from comments to cells with line feed
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
colofnature[_81_] colofnature[_81_] is offline
external usenet poster
  
Posts: 1
Default Copying text from comments to cells with line feed

This works if you turn on text wrapping in the cell:

Function comment2cell(rTarget As Range) As String
comment2cell = rTarget.Comment.Text
End Function

Note that if rTarget doesn't have a comment or is 1 cell this return
#VALUE.

Co

--
colofnatur
-----------------------------------------------------------------------
colofnature's Profile: http://www.excelforum.com/member.php...fo&userid=3435
View this thread: http://www.excelforum.com/showthread.php?threadid=55939

Reply With QuoteReply With Quote