Ark68
Well-known Member
- Joined
- Mar 23, 2004
- Messages
- 4,564
- Office Version
- 365
- 2016
- Platform
- Windows
I am having a problem (more likely just a brain fart of sorts) with this code ...
I am trying to coipy worksheet WSName (variable) to the workbook set it worksheet ws_atr and rename it to the variable tab_sal.
The sheet isn't copying.
Code:
Set ws_atr = Worksheets(WSName).Copy
ws_atr.Name = tab_sal
I am trying to coipy worksheet WSName (variable) to the workbook set it worksheet ws_atr and rename it to the variable tab_sal.
The sheet isn't copying.