Hi



I have done what you have indicated in your spreadsheet and can recreate the problem. However I could not recreate it in a copy of the spreadsheet.
I tried it on a new spreadsheet and could not recreate the problem.
I copied your sample data to a new spreadsheet and could not recreate the problem.
I can only deduce there is a problem with your spreadsheet.
I have attached my sample so you can see.
Hope this helps.
Good luck.
Tony

Attached Files

Comments Spreadsheet Test.xlsx (23.4 KB, 15 views)

Hmmmmm....

Maybe you're right Tony, it could be the spreadsheet. I hope I find a resolution though without having to sacrifice my xls, and the many hours of hard work that I put into creating it.

Thanks for taking a stab at my problem

ok

You could try coping all your data to a new spreadsheet (NOT SaveAs).
And see if that cures the issue.
Tony

You're right, this does work.

The comments seem to reset to their initial "lay-out" in the new spreadsheet.

Again...thanks Tony, appreciate the help

ok