stephicohu
New Member
- Joined
- Jan 27, 2023
- Messages
- 26
- Office Version
- 365
- Platform
- MacOS
This is Stephanie, again, I was informed that I didn't need to use select option in coding as much. I am wondering if I could condense this code:
Sheets("5 month").Activate
Range(Cells(3, 33), Cells(7, 33)).Copy
Sheets("Sheet2").Activate
Range(Cells(3, 2), Cells(7, 2)).Select
ActiveSheet.Paste Link:=True
Can I have combine the sheets("5 month").Range(Cells(3,33), Cells(7,33)).Copy?
Thanks
Sheets("5 month").Activate
Range(Cells(3, 33), Cells(7, 33)).Copy
Sheets("Sheet2").Activate
Range(Cells(3, 2), Cells(7, 2)).Select
ActiveSheet.Paste Link:=True
Can I have combine the sheets("5 month").Range(Cells(3,33), Cells(7,33)).Copy?
Thanks