bryan469,

You could copy the comments to a different sheet, refresh the data, then copy them back