Every morning, I copy data from an external source and paste into Excel. This gives me work order information from the previous day except for one problem: I do not need the pasted data in column G. Starting from a blank worksheet, I run this code to paste the data:
Sub Paste_Copied_Data()
Range("A1").Select
ActiveSheet.paste
Range("L18").Select
End Sub
When I then try to remove the pasted data in column G with the following macro, all my data gets deleted instead of just column G:
Sub Macro1()
'
Columns("G:G").Select
Selection.Delete Shift:=xlToLeft
End Sub
How do I paste my data and then have the code delete column G without deleting anything else? What am I doing wrong?
Sub Paste_Copied_Data()
Range("A1").Select
ActiveSheet.paste
Range("L18").Select
End Sub
When I then try to remove the pasted data in column G with the following macro, all my data gets deleted instead of just column G:
Sub Macro1()
'
Columns("G:G").Select
Selection.Delete Shift:=xlToLeft
End Sub
How do I paste my data and then have the code delete column G without deleting anything else? What am I doing wrong?
