Try

ThisWorkbook.Sheets(1).Columns(1).delete

--
Regards,
Tom Ogilvy


"Paul" wrote in message
news:dQaKd.11226$rw.5302@fed1read04...
The problem I am having is with the object structure of Excel.

For instance I import some data into the first sheet, then I try to
delete the first column, since I don't need the data, but it doesn't see
to work this way.

Private Sub Workbook_Open()

...
code to load in some data..
...

'then I would like to delete the extraneous data with something like

Sheets(1).Columns(1).delete

'but this doesn't seem to be the way it's done.

Can I only work with selections, or do I have to set the object
reference for the function?

Any sites or advice appreciated.

Paul