Error when selecting last row

**therealjag** · 10-07-2009, 07:20 AM

Hey there,

I am trying to delete all the data on "Sheet1" of my spreadsheet except row 1 but using the code below, I keep getting an error when the macro is trying to calculate the end row and column, can any tell me where I am going wrong...and to stop me from going bonkers?!

Please Login or Register  to view this content.

Cheers,

Jag

**StephenR** · 10-07-2009, 07:37 AM

When you run the macro, which sheet is active and which sheet do you want cleared...?

**therealjag** · 10-07-2009, 07:49 AM

Hey Steve, I'm using that button on the NC Sheet Info to activate the macro. The macro should then clear all the data on "Sheet1" except of course the top row which is my header row.

**StephenR** · 10-07-2009, 07:50 AM

I was gently trying to point out that the macro calculates the extent of the data based on the active sheet, which is not the sheet containing the data when you press the button. Change references to ActiveSheet to oSheet.

EDIT: try this

Please Login or Register  to view this content.

**therealjag** · 10-07-2009, 07:59 AM

Oh I see...yeah I've just amended that again actaully and it works! I really need to get a grip of using with and end with statements so I'll look into that now...thanks for your help