| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete multiple rows
Hi! I was hoping for some help. I have a workbook that has 50
worksheet, all of which are identical. I need to clean up the data and delete several rows from each sheet. Each sheet is roughly 500 rows long, and the rows I need deleted are sporadic. Some are blank rows, and some are totals. Via vba, can I delete certain rows quickly? Thanks! -Steph |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Delete multiple rows
Hi Steph
Do you mean that you want to delete the same rows on each sheet? Do you know the row numbers or do you want to loop through all rows on each sheet to check the values?? Please give more information -- Regards Ron de Bruin (Win XP Pro SP-1 XL2000-2003) www.rondebruin.nl "Steph" wrote in message om... Hi! I was hoping for some help. I have a workbook that has 50 worksheet, all of which are identical. I need to clean up the data and delete several rows from each sheet. Each sheet is roughly 500 rows long, and the rows I need deleted are sporadic. Some are blank rows, and some are totals. Via vba, can I delete certain rows quickly? Thanks! -Steph |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hpw do I delete multiple empty rows found between filled rows? | Excel Worksheet Functions | |||
| Delete rows with multiple columns with 0 value | Excel Discussion (Misc queries) | |||
| Delete all rows below certain value on multiple worksheets? | Excel Discussion (Misc queries) | |||
| How to delete multiple rows w/ a macro? | Excel Discussion (Misc queries) | |||
| Delete Blank Rows Code - Multiple Worksheets - Multiple Documents | Excel Discussion (Misc queries) | |||
![Steph[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
