Deleting content from multiple sheets excluding the headings of the content

[abhijit781]

Hi
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
I need a help regarding a macro for one of my reports. I have a excel sheet with some tabs. Every time I’m generating a report I have to delete the content of all the tabs from previous report excluding the headings. For example I have a sheet with 3 tabs Jan, Feb and Mar.I want content of the each tab to be deleted but not the headings(i.e. the 1st row should not be deleted).
I’m able to delete the content by a macro but not able to do at a time for all the 4 sheets. Could anyone please help me out?

 

[John_w]

Try this:

    Dim ws As Worksheet
    For Each ws In Worksheets
        ws.UsedRange.Offset(1, 0).Delete
    Next

 

[abhijit781]

yep it's working Many thanks Johnray:ray: