Count all non-blank cells in column 1 of the table on the active sheet. 'Save this number of cells as variable "TransQty". 'If count is 0, message "No projects on this tab are marked for transition". 'If count is greater than 0, yes/no message "'TransQty' projects will be transitioned from this tab. Would you like to proceed?" 'If "no", end. 'If "yes", proceed with the rest of the code.
Counts nonblank results when evaluating the result of an expression over a table. That is, it works just like the COUNTA function, but is used to iterate through the rows in a table and count rows where the specified expressions results in a non-blank result.