M MFS May 2, 2009 #1 I would like to change the sheet direction by default. Also if it is possible, how to extract data from comment to cell.
I would like to change the sheet direction by default. Also if it is possible, how to extract data from comment to cell.
J Jacob Skaria May 3, 2009 #2 Revised... Function GetComment(varRange As Range) As String For Each c In varRange If Not c.Comment Is Nothing Then GetComment = GetComment & c.Comment.Text & "," End If Next End Function If this post helps click Yes
Revised... Function GetComment(varRange As Range) As String For Each c In varRange If Not c.Comment Is Nothing Then GetComment = GetComment & c.Comment.Text & "," End If Next End Function If this post helps click Yes
A Ashish Mathur May 4, 2009 #3 Hi, You may want to refer to question 46 of the following link - http://ashishmathur.com/replies.aspx -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com
Hi, You may want to refer to question 46 of the following link - http://ashishmathur.com/replies.aspx -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com
