Excel Excel 2007 Copy Comments to Cells

Mar 27, 2012
Reaction score
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