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

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