I need to use a value in a cell to create a cell reference. What I'd like to
do is almost accomplished by the address function, but address returns it as
text rather than a cell reference.

Example:
I have numerous sample records in a spreadsheet that summarizes sampling
results. The number of records varies will vary from workbook to workbook,
and I'm trying to automate through use of a template without getting into
visual basic stuff (which I know very little about).

So,I use the count function in Cell A3 to count the number records on the
sheet. The result comes back a whole number...say "20" in this case. Then,
I want to refernce a range of cells that includes cell C4:C24 (i.e. the
vertical range based on the 20 records)in order to count all the blank cells
in the range.

I looked through all the available functions, and couldn't find anything
that I thought would help (except address). Anybody have suggestions?
Thanks in advance!