I am using a form to enter values into cells in a column. The number o
cells varies each time the template is used.

I need to select the range of cells, calculate the total and read tha
total into another cell.

I know how to select a fixed range but the problem I have is how t
select the range when the number of cells varies.

Hope this makes sense. Can anyone help?

Geof

--
Message posted from http://www.ExcelForum.com