Hattie
New Member
- Joined
- Oct 7, 2020
- Messages
- 18
- Office Version
- 365
- Platform
- Windows
the following line of code works but copies from sheet4 to sheet2
i want to specify different source sheets from time to time.
How do i replace the static sheet4 in the line below with a cell reference
so i can just type a sheet name of the source sheet into cell a1of the target sheet?
how do i replace sheet2 with the current sheet i am on (the target sheet)
'Copy cell to another cell
Sheets("Sheet4").Range("A1").Copy Sheets("Sheet2").Range("B11")
thanks
i want to specify different source sheets from time to time.
How do i replace the static sheet4 in the line below with a cell reference
so i can just type a sheet name of the source sheet into cell a1of the target sheet?
how do i replace sheet2 with the current sheet i am on (the target sheet)
'Copy cell to another cell
Sheets("Sheet4").Range("A1").Copy Sheets("Sheet2").Range("B11")
thanks