Cut and paste cell comments using a macro

[bc2010]

I have the following macro that will shift a selection of data to the left by one month so that people can enter and view data throughout the year in three month 'views' and shift each month as they go by. The problem is that the comments do not get moved (cut and pasted I assume). They stay attached to the same cell that they were entered into originally. Is there something that can be added to this code that will move the comments along with the other cell data when the macro is executed? I have some programming skills but this is all new to me! I would appreciate any help!

Thanks

The code:

Please Login or Register  to view this content.

[Leith Ross]

Hello bc2010,

The easiest method is to change your paste statement.

Code Change From:
Selection.PasteSpecial Paste:=xlValues

Code Change To:
Selection.PasteSpecial Paste:=xlPasteAll

Sincerely,
Leith Ross

[bc2010]

Thanks a bunch! I did have to add some code after the copy command to delete the existing comment as well after copying but it seems to be working!

Thanks again!