Hello all. I spent a few hours last night and this morning combing through the forums trying to find a macro to suit my specific needs for printing, I didn't find anything with quite the same crieteria, and would appreciate any assistance you can offer. First of all, I am very new to VBA, so finding some relevant script portion that I can adapt to my needs is not an option at this point, however I hope that will be the case soon.

I have a worksheet (named Pay Report) that I want to have printed. This particular worksheet is protected as everything on it is formulas. Now I want to determine how many of the pages on Pay Report mus be printed by the value in cell C14 on another worksheet tab called Team List. Cell C14 contains a COUNTA formula. This formula basically counts the number of staff members. The formulas on the Pay report tab are set up so each staff member gets their own detailed marketing report to validate the amount of their bonus check.

Currently C14 provides a count of 25, however that can increase or decrease based on the number of staff on hand. Any help would be greatly appreciated! thanks so much!