FrankMcNally
Board Regular
- Joined
- Nov 14, 2014
- Messages
- 71
Hey,
What is the Code for Copying Cells: A1 and C1 from Sheet 1 to A1 and B1 on Sheet 2 in one command? By one Command I mean rather than:
I actually need to copy them from one Workbook to another, but one problem at a time
What is the Code for Copying Cells: A1 and C1 from Sheet 1 to A1 and B1 on Sheet 2 in one command? By one Command I mean rather than:
Code:
Sheets(Sheet1).Range(A1).Value.Copy
Sheets(Sheet2).Range(a1).paste
Sheets(Sheet1).Range(c1).Value.Copy
Sheets(Sheet2).Range(b1).Paste
I actually need to copy them from one Workbook to another, but one problem at a time