Excel Excel 2007 Copy Comments to Cells

D

dltoney

Joined
Mar 27, 2012
Messages
2
Reaction score
0
I have copied Comments to their own cells in my Excel file using vba. The Comments in the new cells do not seem to actually contain the value that they are showing. The Comment "appears" in the cell but the value really isn't there in the formula bar.

I eventually need to save the Excel file as CSV to import elsewhere and I need the Comments to be there own separate field that I can import.
 

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

Excel Import Comments 3
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Word to Excel: Export comments with text and line number 0
Excel VBA 1
Excel Import XML into Excel 0
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Excel Image / photo not moving with cell in Excel when sorted 0
Import 4 Different Excel Files from One Folder 0

Top