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