Darren Smith
Well-known Member
- Joined
- Nov 23, 2020
- Messages
- 631
- Office Version
- 2019
- Platform
- Windows
Hi All
Can someone tell me why this code below is not working.
I think it copies ok but won't paste into merged cells.
It's copying from merged cells to merged cells in separate worksheets.
Can someone tell me why this code below is not working.
I think it copies ok but won't paste into merged cells.
It's copying from merged cells to merged cells in separate worksheets.
VBA Code:
If ListBox4 = "Add Data to Jobcard Analysis Sheet" Then
Dim wsSource As Worksheet
Dim wsDest As Worksheet
Set wsSource = ThisWorkbook.Sheets("Job Card Master")
Set Dest = ThisWorkbook.Sheets("Job Card with Time Analysis")
wsSource.Range("G2").Copy
wsDest.Range("G2").PasteSpecial xlPasteValues
End If
End Sub