Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can we delete rows permanently from excel sheet
In my excel sheet i have total 4363 rows.
From this i am generating comma delimited text file through macros. I want information of only first 2000 rows and rest rows are empty. This empty rows are generating unecessary commas in txt files and i have to always delete this. I tried to delete rows 2001 and onwards but i am not able to delete. I can add a row but cannot delete this permanently. Is there any way to do this? Thanks Nehal Shah |
#2
|
|||
|
|||
You can't delete the rows only the values in it
But you can hide them Range("A2001:A" & Rows.Count).EntireRow.Delete Range("A2001:A" & Rows.Count).EntireRow.Hidden = True -- Regards Ron de Bruin http://www.rondebruin.nl "Nehal Shah" <Nehal wrote in message ... In my excel sheet i have total 4363 rows. From this i am generating comma delimited text file through macros. I want information of only first 2000 rows and rest rows are empty. This empty rows are generating unecessary commas in txt files and i have to always delete this. I tried to delete rows 2001 and onwards but i am not able to delete. I can add a row but cannot delete this permanently. Is there any way to do this? Thanks Nehal Shah |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
delete extra columns and rows | Excel Discussion (Misc queries) | |||
Updating rows - Excel Formula or Something Else? | Excel Worksheet Functions | |||
How do I import data into Excel that exceeds 70000 rows? | Excel Discussion (Misc queries) | |||
How to delete duplicate rows in Excel 2000? | Excel Discussion (Misc queries) | |||
How do I remove blank rows in Excel? | Excel Discussion (Misc queries) |