VBA Code Editing Help Requested

[Justinian]

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?

 

[Justinian]

Use the CALL procedure

SUB Cpy_Pste()
CALL  ModuleName.Paste_Copied_Data
CALL ModuleName.[COLOR=#333333]Macro1[/COLOR]
End Sub

I do not want macro 1 in here. I just recorded it so I could get the code to delete column G.

 

[Justinian]

Yes I think it would.

Here is the link:

https://app.box.com/s/6b8qrp231nz97eceq2yh1qu8825fk3hj

I already pasted the data into the workbook so you can see what it looks like. All I need to do is remove column G, leaving all other data and I want to combine the removal of column G with an existing macro, not a new one.

 

[Fluff]

Just replace this line

Worksheets("Macro").Range("G1").Select

with

Worksheets("Macro").Range("G:G").Delete

In your Remove_Unwanted macro

 

[Justinian]

Wow, the answer was staring me in the face and I missed it!

Thank you!

 

[Fluff]

Glad to help & thanks for the feedback

 

[Justinian]

I spoke too soon. It worked last night but now it will not because when I run the "Remove Unwanted" macro, I get a message that says "this operation will casue some merged cells to unmerge," but I have no merged cells in here. I do not understand why it worked last night but not now.

 

[Fluff]

A5:K5 is one merged cell

 

[Justinian]

Ok, I see that now but when I highlight column G and delete manually, it deletes with no problems. Why will it not perform the same way when I run the macro? How do I solve the problem?

 

[Fluff]

The macro works fine for me. Can you upload another file, where it's causing problems?

 

[Justinian]

Here you go:

https://app.box.com/s/6b8qrp231nz97eceq2yh1qu8825fk3hj