Clearcontents of range on multiple worksheets

Hi there anyway this macrop can be modified to make it more compact

Thanks

Please Login or Register  to view this content.

You only need to add one set of [.CODE] and[./CODE]

Maybe an array or try

Please Login or Register  to view this content.

VBA Noob

Thanks for the reply I'll give it a try and thanks for the code thingo, I was still reading when you fixed it for me...

Regards
Stephen

Just tried it and works flawlessly

Glad it helped

Thx for the feedback

VBA Noob