suggest using a defined name range such as
inserttnamedefinename it something like myrng
in the refers to box
=offset($a$1,0,0,counta($A:$A),6)
then refer to the name. modify to suit

--
Don Guillett
SalesAid Software

"George" wrote in message
...
Hi,

I have a table with a certain number of rows. I don't know how many rows
there are in the table. I can make a data cell that holds the number of
cells
in a particular column.

My question is this - Can I then use this figure to make a range to be
able
to use inside other formulas in the worksheet?

For instance, the data cell works out there's 743 valid rows in the sheet.
Can I then use this to make a formula in another cell?

I want to get my formula (SUMPRODUCT) which doesn't accept shorthand for
the
column ($C:$C) be flexible enough to cope with people adding extra values
in
which need to be incorporated into the formula :-)

Thanks
George