Macro run time error

[Finalfrontier1976]

Hi guys,

I'm creating a basic macro to remove some columns from a series of information.

The idea is to paste the complete sheet from the attached file (Sheet 2) and paste in into the "Paste..." tab in the other attached spreadsheet.

By pressing ctrl+shift+t after pasting the macro will remove certain columns and leave the results behind. The columns to remain are:

Drivername
Department
StartTime
EndTime
Duration

The macro I've created will do that but after it's finished I'm getting a run time error. Can anyone suggest a way to improve or clean that macro up so I don't get this. The amount of entries differs each week so I can't use a predefined number of rows (should that info be needed).

I'm leaving the company and passing this onto someone with very basic Excel knowledge so looking to keep this error free as possible.

However, would there be a further improvement to create a button on another sheet in my workbook so if the person clicks this it would do all the formatting in the "Paste..." sheet in the workbook?

Thanks,
Lew

[Olly]

Your run time error is caused by the last line, which is trying to select a range in a table that doesn't exist:

Please Login or Register  to view this content.

Delete the line I've highlighted in red, and it will run without error.

You could simplify to:

Please Login or Register  to view this content.