Hey Everyone, I've looked at a few different posts about copying and pasting data and not sure what I'm doing wrong. I'm trying to select everything from one sheet and copy it to another sheet starting in cell B2. Please tell me where I'm going wrong:
Private Sub CopyData_Click() Sheets("4").Activate ActiveSheet.Range("A1", "B1006").Select Selection.Copy Sheets("5").Activate ActiveSheet.Range(“B2”, "C1007").Select Selection.Paste End Sub
Bookmarks