IsEmptyWorksheet(ActiveSheet)

[Calvin De Beverly]

Hi. I am studying the book Excel 2002 VBA by Stephen Bullen et.al. and one of his examples is the following line of code:

If Not IsEmptyWorksheet(ActiveSheet) Then Exit Sub

He is trying to ensure that the the proceedure begins with a fresh clean work sheet. However, when I try to run it I get an error that says the "sub or function is not defined". So far none of his examples have had a problem and I was wondering why this might not be working? I am running Excell 2003. Is this function no longer support? That is the only thing I can think of. Any ideas?

Thank you.

[TMS]

IsEmptyWorksheet isn't an off the shelf function. Have you copied it into your workbook?

I obviously can't see the context but I can't really see the value of the function. If you want to start with a clean sheet, you could just delete all the cells. Or you could delete the sheet and create a new one.

Regards, TMS

[Calvin De Beverly]

Thank you TmShucks. You were spot on. The author made reference to the function before actually showing me the function on the next page. My bad. Sorry for wasting time. Have a good day.