Sheet direction, extract data from comment

  • Thread starter Thread starter MFS
  • Start date Start date
M

MFS

I would like to change the sheet direction by default.
Also if it is possible, how to extract data from comment to cell.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

GETPIVOTDATA and (blank) 0
Total cells when range is unknown 4
extracting sheets on the basis of Row character 1
how can i transfer data from one sheet to another without blank li 1
using the =page! feature to transpose a row to column 0
Printing Worksheet 1
Link Cells with Comments 1
Sheet order & speed 1

Back
Top