Rebeccahelp needed
New Member
- Joined
- Sep 7, 2020
- Messages
- 9
- Office Version
- 365
- Platform
- Windows
Hi.
Am using the below to copy data from E2:G2 (and down to bottom of completed cells). into Stock report - bottom of data in column A.
Sometimes it works and copies data in E to G - sometimes only what is in G???
Range("e2").Select
Dim UsdCols As Long
UsdCols = Cells(2, Columns.Count).End(xlToLeft).Column
Range("e2", Range("e" & Rows.Count).End(xlUp)).Resize(, UsdCols - 6).Copy
With Sheets("Stock Report")
.Range("A" & Rows.Count).End(xlUp).Offset(1).PasteSpecial xlPasteValues
End With
Application.CutCopyMode = False
Thanks for your help
Am using the below to copy data from E2:G2 (and down to bottom of completed cells). into Stock report - bottom of data in column A.
Sometimes it works and copies data in E to G - sometimes only what is in G???
Range("e2").Select
Dim UsdCols As Long
UsdCols = Cells(2, Columns.Count).End(xlToLeft).Column
Range("e2", Range("e" & Rows.Count).End(xlUp)).Resize(, UsdCols - 6).Copy
With Sheets("Stock Report")
.Range("A" & Rows.Count).End(xlUp).Offset(1).PasteSpecial xlPasteValues
End With
Application.CutCopyMode = False
Thanks for your help