Macro to sort info on worksheet

[SilverFox]

Could someone please help me with this?

I need a macro to clear data on 2 worksheets that i can add to a button

lets say sheet1 B55:Y55 and sheet2 b102:y102

[SilverFox]

I have edited this now, if someone can help it would be very much appreciated

[StephenR]

Do you mean like this? Use ClearContents if you want to keep formatting.

Please Login or Register  to view this content.

[SilverFox]

Thanks for that it worked a treat