I've been using the following code to count the number of employees that participated in a particular job task:

NumOfWorkers = Application.CountA(Sheets("Paycard").Range("F3:K3")

I need to know if it's possible with this function to now set the "Range" portion of it to a constantly changing set of variables? What is the syntax?

For example, as I adjust the variable 'currentrow' plus one after each loop, I need to know the NEW number of workers for that particular row, not just row 3.

Make sense? Help?