Takes2ToTango
Board Regular
- Joined
- May 23, 2023
- Messages
- 63
- Office Version
- 365
- Platform
- Windows
Hi all,
Not sure if this question has been asked before.
I am currently trying to run a function where i copy and paste columns into a new sheet - including dates. However, when dates get pasted they automatically paste in as '05/01/1900'. Is there any way around this? I have added my code below.
I have checked the format and they are both 'date' formats.
Not sure if this question has been asked before.
I am currently trying to run a function where i copy and paste columns into a new sheet - including dates. However, when dates get pasted they automatically paste in as '05/01/1900'. Is there any way around this? I have added my code below.
I have checked the format and they are both 'date' formats.
VBA Code:
ws.ListObjects("Table1").ListColumns(3).DataBodyRange.Copy
wsasn.Range("G2").PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False