runtime error 1004

[Dharmesh]

hello

I have some coding which exports a file and then deletes a certain column. I have some coding which does this, it works sometimes, but sometimes it comes up with a runtime 1004 error. Below is the code, does anyone have a clue why it doesnt work. All im trying to do is delete column G from the file.

Range("A1").Select
Columns("G:G").Select
Selection.Delete Shift:=xlToLeft
Range("A1").Select



Thanks

Dharmesh