Removing data macro

[Sweepin]

All,

I'm trying to remove data in the attached sample from some spreadsheets. The problem is that the row numbers will change for each spreadsheet and this table appears twice in each of my spreadsheets. Any thoughts?

TIA

sample.xlsx

[patel45]

What data do you want remove ? all ?
if all

Please Login or Register  to view this content.

[Sweepin]

Yeah I want to remove all the data from Advanced Box Score Stats to the team totals line. I can't remove all the cells contents because the table is only a piece of the whole sheet.

[patel45]

Please Login or Register  to view this content.