Small Paul
Board Regular
- Joined
- Jun 28, 2018
- Messages
- 118
Hi
I have 2 workbooks. Workbook A contains 1 worksheet. Workbook B (purchased items) has a variable number of worksheets.
I need to copy the worksheet in A and add it to be the LAST worksheet in B.
The code I have at present is:
When run, the name is changed and the worksheet is copied.
However, it does not appear in 'Purchased Items'
I know it is something simple but can somebody please help?
Cheers
Small paul.
I have 2 workbooks. Workbook A contains 1 worksheet. Workbook B (purchased items) has a variable number of worksheets.
I need to copy the worksheet in A and add it to be the LAST worksheet in B.
The code I have at present is:
Code:
Sub Macro1()'
' Macro1 Macro
'
activesheet.name = "Payee Details"
activesheet.Copy
after = Workbooks("Purchased Items.xlsm").worksheets.Count
End Sub
When run, the name is changed and the worksheet is copied.
However, it does not appear in 'Purchased Items'
I know it is something simple but can somebody please help?
Cheers
Small paul.