Tables and clear format in worksheet

[jaryszek]

Hi,

i have a lot of listobjects in one worksheet and what want to achevie is to clear formats from them.

I recorded macro:

Please Login or Register  to view this content.

But you can see for each listobject there is separeted statement. It is possible to do it in one command?

Best,
Jacek

[romperstomper]

You can just loop

Please Login or Register  to view this content.

[jaryszek]

thank you Rorya very much for help!

Jacek