Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro that Deletes All rows except first row
Greetings everyone! How can I delete all rows in an excel sheet except the first row? I have an excel sheet where the first row has header information and the subsequent rows contains data. I would like to run a vba macro that clears/delete all the data , starting from row 2, in the excel sheet but retains the header information in row 1. Curtney Jacobs -- curtney ------------------------------------------------------------------------ curtney's Profile: http://www.excelforum.com/member.php...o&userid=36469 View this thread: http://www.excelforum.com/showthread...hreadid=562327 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro that deletes rows from cell containing End to end of data. | Excel Discussion (Misc queries) | |||
Macro that deletes certain rows only | Excel Programming | |||
Why xl deletes 250+ rows using worksheet_change | Excel Programming | |||
Help With a Loop That Deletes Rows | Excel Programming | |||
Macro that deletes certain rows and not others | Excel Programming |