Excel Excel 2007 Copy Comments to Cells

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.
 
Back
Top