Dazzawm
Well-known Member
- Joined
- Jan 24, 2011
- Messages
- 3,748
- Office Version
- 365
- Platform
- Windows
I have this part of code within a macro that creates a new sheet. What needs adding to it so that it is formatted as text so that when data is put on this sheet it does not lose leading zeros?
Thanks
Set targetSheet = Worksheets.Add(After:=Worksheets(Worksheets.Count))
Thanks
Set targetSheet = Worksheets.Add(After:=Worksheets(Worksheets.Count))