Recorded Macro returns Run-time error '1004'

Hi,

I recorded a macro to do the following:

1. Delete Columns 'F' (Time) and 'G' (Room).
2. Insert new 'G' column with the title 'Time 1'
3. Insert new 'I' column with the title 'Time 2'
4. Insert new row number 1
5. Insert new row number 2
6. Fit cells to contents (Select all cells and double click border)

When I run the macro on a different sheet within the same workbook I get the following error

Run-time error '1004':

Method 'Range' of object'_Global' failed

Here is the VBA script that excel created:

Please Login or Register  to view this content.

When I hit the 'Debug' button, it highlights

Please Login or Register  to view this content.

Many thanks in advance and happy new year,
absconditus

PS I'm VBA-illiterate.

You do not have Table15 in other sheets so to do it as easy as possible, change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

and below

Please Login or Register  to view this content.

Please Login or Register  to view this content.