Copy from one tab to another - code not working

[gheyman]

This is copying what's in columns C:G and pasting them correctly but its not copying the second piece (L11 & LstRw)

Sub Grab_BOEs()

Dim LstRw As Long

Sheets("54_TPL_01_02 Consolidate").Activate
LstRw = Range("C" & Rows.Count).End(xlUp).Row

'WBS Number, WBS Title, Task Start, Task End, Resource Code
Sheets("54_TPL_01_02 Consolidate").Range("C11:G" & LstRw).Copy
 Sheets("Load_Table").Select
    Range("A11").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
        
'Estimated Amount
Sheets("54_TPL_01_02 Consolidate").Range("L11" & LstRw).Copy
Sheets("Load_Table").Select
    Range("G11").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False



End Sub

 

[Takae]

It missed column letter.
Sheets("54_TPL_01_02 Consolidate").Range("L11" & LstRw).Copy

The first one has "G"
Range("C11:G" & LstRw).Copy

 

[gheyman]

Thanks!