Macro to clear Data from Speficic sheet to last sheet

[Howardc1001]

I have written code to clear all data from sheet "Units" to last sheet.


I get a run time error -"object doesn't support this property or object

It would be appreciated if someone could assist me

Please Login or Register  to view this content.

[Fluff13]

Try

Please Login or Register  to view this content.

[Howardc1001]

Thanks for the help, much appreciated

[Fluff13]

You're welcome & thanks for the feedback