I have a few named ranges on various worksheets. I can use VBA to hop back
and forth between these sheets with no difficulty. Now, I need my program to
count the cells in a named range and then store that value as a variable.

Example:
I have a named range called "lists" in a single column on a worksheet. I
need to engage a For loop that uses the number of cells in "lists" as its
upper bound. i.e. say "lists" contains 92 cells I need a line of code that
counts the number of cells in "lists" (92) and then sets x = 92. The size of
"lists" is not static, thus i can't just use the number 92; I actually need
the value returned by the count function to be stored as x for later use in a
for loop.

Any help would be greatly appreciated.

Thank you very much,
Nate