AlexanderBB
Well-known Member
- Joined
- Jul 1, 2009
- Messages
- 2,097
- Office Version
- 2019
- 2010
- Platform
- Windows
VBA Code:
Sub CopyComments()
Dim W As Workbook, W1 As Workbook, Sh As Worksheet, Sh1 As Worksheet
Set W = Workbooks("Workbook1.xlsx")
Set W1 = Workbooks("Workbook2.xlsx")
Set Sh = W.Worksheets("HR&Finance")
Set Sh1 = W1.Worksheets("Budget")
Sh.UsedRange.Copy
W1.Activate: Sh1.Activate
Sh1.Range("A1").PasteSpecial Paste:=xlPasteComments, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
Application.CutCopyMode = False
End Sub
But I'm a bit wary - what comment is affected? I don't want to do all just some of them, one at a time.
And do I want SkipBlanks, Transpose etc as shown?
Any help appreciated,