Is there a function similar to =countif for macros?

[ahilty]

I currently have a large macro covering data on 31 sheets. The macro works currently as is but what happens requires a lot of user input and I would like to get rid of that.

The macro currently asks the user is there is data on sheet 1. If the user says yes, it copies and pastes the range (A13:P72) into sheet 32.
The macro asks this yes or no question for nearly every sheet. It's annoying to have to push yes 30 times....

I was wondering if there was a way to go from sheet to sheet checking to see if there was data in the following ranges (A13:B72 and P13:P72)
if yes, copy and paste, if no, check the next page.

Any ideas? - hopefully this is explained well enough.

Thanks again everyone for the help.

[AB33]

The countif functions works the same as in excel, all you need to is precede the function with application as there is no counitf VBA function. You can get it from excel.

[ahilty]

I see. Well that seems kind of silly. Thank you for the help.