Need a Macro for reset (remove selected range data) our project sheets

Hello Team
We want a macro for reset (remove selected range data) our project sheets
we want to reset data in 3 sheet
1 Details
2 Summery
3 Setup

In DETAIL sheet We want remove all row column data FROM
CELL VALUE A6: TO END OF ROW & END OF COLUM

In SUMMERY sheet We want remove all row column data FROM
CELL VALUE A7: TO END OF ROW & END OF COLUM

In SETUP sheet We want remove CELL VALUE B2 & F2

My sample file is also attach

Thanks in Advance
>santosh

Hi Patel..
thanks for looking intrest in my problem.
we want a clear contents in sheets..... with single macro for above 3 sheet run when we run that macro

Thanks

Please Login or Register  to view this content.

sir macro works as per my requirement.. but we want few more in following

after unmerge cell.... macro can't merge b2 : d2 cell

with macro data clear but outline not clear

thanks for ur reply..

Clear method clears all, including formatting

Please Login or Register  to view this content.

Thanks you AB33 we solve my problem with your valuable help