不使用剪贴板将注释从一个工作表传输到另一个工作表

I have a VBA script which add's comments to a background worksheet, which is working great. The problem I am having is moving this to a front worksheet.I have a VBA script which add's comments to a b