gheyman
Well-known Member
- Joined
- Nov 14, 2005
- Messages
- 2,347
- Office Version
- 365
- Platform
- Windows
My code doesn't like the first line. The name of the tab is correct
Sheets("BOE").Cells("C5:C1015").Selection.Copy
Sheets("Export Load Table").Select
Sheets("Export Load Table").Range("A3").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
Never Mind
Sheets("BOE").Activate
Range("F5:F1015").Select
Selection.Copy
Sheets("Export Load Table").Activate
Sheets("Export Load Table").Select
Range("D3").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
Sheets("BOE").Cells("C5:C1015").Selection.Copy
Sheets("Export Load Table").Select
Sheets("Export Load Table").Range("A3").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
Never Mind
Sheets("BOE").Activate
Range("F5:F1015").Select
Selection.Copy
Sheets("Export Load Table").Activate
Sheets("Export Load Table").Select
Range("D3").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
Last edited: