| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete rows Macro
Hi,
I need a macro that will select all rows from below the last entry to the end of the workbook, and delete them. Deleting is fine, but can't get it to find the last row with data and choose from below. Ta, |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Delete rows Macro
You cannot actually delete those rows, there will always be 65536 rows. If
you delete the last say 10 rows, Excel just inserts 10 new ones. -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "smf" wrote in message ... Hi, I need a macro that will select all rows from below the last entry to the end of the workbook, and delete them. Deleting is fine, but can't get it to find the last row with data and choose from below. Ta, |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Delete rows Macro
Ok, thats fine. That is what I want to do.
"Bob Phillips" wrote: You cannot actually delete those rows, there will always be 65536 rows. If you delete the last say 10 rows, Excel just inserts 10 new ones. -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "smf" wrote in message ... Hi, I need a macro that will select all rows from below the last entry to the end of the workbook, and delete them. Deleting is fine, but can't get it to find the last row with data and choose from below. Ta, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to delete rows | Excel Discussion (Misc queries) | |||
| delete rows using macro | Excel Worksheet Functions | |||
| Using a Macro to delete all rows containing #N/A | Excel Programming | |||
| macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
Linear Mode
