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