Copying Comments

[pells]

Is it possible to copy and paste comments within a sheet via VBA? I read that the xlPasteComments is the correct command but I am already using aste:=xlPasteFormulasAndNumberFormats and was wondering whether xlPasteComments can be incorporated too?

This is what I am currently using which works fine except the comments dont coy:

Selection.PasteSpecial Paste:=xlPasteFormulasAndNumberFormats, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False Operation:= _
xlNone, SkipBlanks:=True, Transpose:=False
Many thanks for any help that you can give.

 

[VoG]

Try adding another line

Selection.PasteSpecial Paste:=xlPasteFormulasAndNumberFormats
Selection.PasteSpecial Paste:=xlPasteComments

 

[pells]

Try adding another line

Selection.PasteSpecial Paste:=xlPasteFormulasAndNumberFormats
Selection.PasteSpecial Paste:=xlPasteComments

I should have tried that, apologies! Many thanks, this works perfectly