count excel cells

Hi,

I'm working on a macro for excel to organize/format my test data. One thing I'm stumped on is a counting a certain number of excel cells. I need a function that will count the number of excel cells and then execute a formula if there is the right amount of cells. Does anyone know how to do this?

Thanks,
Keegan