See response to original question.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"John Smith" wrote in message
...
I have selected a column and called it "Mark" I need to determine the
number
of rows in this column with values in them at runtime. The number of rows
used in this column will vary.

How do I determine the number of rows with values?

If I use Range("Mark").Rows.Count it appears to return a very large
number.

thank you
mark