I'm using the code below - recorded to move populated cells from one worksheet to another. I have 31 columns of comments to copy from one sheet to another and I can see this macro is very clunky but I can't seem to get the syntax right when I try to remove bits that I think are not necessary. My brain hurts, can someone please give me a pointer in the right direction?
Code:
Columns("B:B").Select
Selection.SpecialCells(xlCellTypeConstants, 23).Select
Selection.Copy
Sheets("Comments").Select
Range("A3").Select
ActiveSheet.Paste
Sheets("HT Review").Select
Columns("D:D").Select
Selection.SpecialCells(xlCellTypeConstants, 23).Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Comments").Select
Range("B3").Select
ActiveSheet.Paste