Delete auto incrementing column in Excel sheet?

Hi,

I m pulling data from .iqy file to Excel sheet. While doing that, It not only fetches my data from iqy file but also adds ID column in Excel which is auto incrementing. How do I get rid of that ID column which is autoincrementing column in my excel sheet?

Here's my code along with screenshot that shows auto incremented column iD which I want to get rid of.
Delete AutoIncrementingCol.JPG

Please Login or Register  to view this content.

Add this before End Sub

Range("A1").EntireColumn.Delete

Hi RaulRodriguez,

I got Run time error 1004
Delete method of Range class failed.

Try adding the worksheet name Worksheets("Sheet1").Range("A1").EntireColumn.Delete