Delete multiple rows

  • Thread starter Thread starter Steph
  • Start date Start date
S

Steph

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
 
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
 
Back
Top