Delete all rows in a spreadsheet except the first row

[jaym911]

Hi I need to clear all rows in a spreadsheet except the top row. this will be a macro that is run automatically when the spreadsheet is closed.
i imagine i would need to find the last row in the spreadsheet and store as a variable though i dont know how to do this.
i guess it would just then require a range selected from cell A2 to I&lastrow (the spreadsheet will only be I columns wide)

any help would be greatly appreciated i dont have any code for this but i dont think it would require much.

thanks

[Leith Ross]

Hello jaym911,

Welcome to the Forum!

This macro will clear all rows and the contents, but the first for the active sheet. This assumes row 1 has headers.

Please Login or Register  to view this content.