Delete all the rows in a spreadsheet except
Closed
Toto
-
Mar 18, 2012 at 03:19 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Mar 18, 2012 at 10:26 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Mar 18, 2012 at 10:26 PM
Hello,
I have a simple question. How to delete all the rows in a spreadsheet except the first 6 rows by macro. Please reply me with an exact code to do this.
I have a simple question. How to delete all the rows in a spreadsheet except the first 6 rows by macro. Please reply me with an exact code to do this.
Related:
- Delete all the rows in a spreadsheet except
- How to delete a row in a table in word - Guide
- Delete my whatsapp account without app - Guide
- Google spreadsheet right to left - Guide
- Spreadsheet function - Guide
- Delete whatsapp account without phone - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Mar 18, 2012 at 10:26 PM
Mar 18, 2012 at 10:26 PM
why do you want a macro. just delete rows 7 to the end
anyhow try this macro
anyhow try this macro
range(range("A1"),cells(rows.count,"A").end(xlup).entirerow.delete