I can't seem to be able to delete columns with any effect. I only use columns A:Q on a sheet, but excel thinks I'm using A:XFD

I have tried.

A) Selecting all columns from S:XFD and deleting them. This just brings in new columns (which should be blank) but contain some border and background formatting matching for the first 5 rows.

B) Selecting all columns from S:XFD and clearing all. Then deleting them.

C) Clearing contents, going to VBA immediate window and typing Activesheet.usedrange - to try and reset the used range

In all three cases if I use the immediate VBA window, it reports the used range to still be 6:186, i.e. all columns are still part of the used range (even if deleted and cleared).


Any ideas please?

thanks, Dom