Delete rows/columns across all worksheets

Hi Guys,

Newb here and I have spent about 4 hours recording macros (then editing them) searching the web, forums, and I still can't get this macro to run properly.

I have a single workbook with 55 worksheets. I need to delete rows #1-14, then delete columns A & B on all worksheets. The macro below seems to be running in a loop which appears to delete rows 1-14 and columns A & B until there is no more data left on the active sheet only. It does not run on any of the other sheets - even if I select all sheets before running the macro.

Please Login or Register  to view this content.

Thanks in advance!

Thanks Leith,

I'm getting a compile error: Invalid outside procedure and 'AllSheets' is highlighted.

Yeah - wow! Thanks guys and sorry for my lazy eyes! Too many hours staring at the comp screen!

Macro ran like a dream!!!

Thanks again!