clear contents of entire sheet except the contents of the table

how could this be achieved please

Select the range of the worksheet that isn't the table and use the .clearcontents command.

Try this: Run the macro recorder, select the range you want cleared and press DELETE. Then stop the macro recorder and look at the code it's written for you.

Hi wayneg,

There is no magic elixir function for your question. Try code like the following which worked for me:

Please Login or Register  to view this content.

Lewis

Long, but does the trick. Just change the reference in red to reference the table you want to keep.

Please Login or Register  to view this content.

Blimey, I'm much lazier than you two. I'd just select the 4 blocks around the table and clear them, all done in 4 lines of code. eg.

Please Login or Register  to view this content.