Hi all,

Sorry for this stupid question. Is it possible to count the number o
rows of a particular column?

I wrote:
1) Worksheets("Settings").UsedRange.Columns(1).Rows.C ount
2) Worksheets("Settings").Columns(1).Rows.Count

Neither works correctly. (first one gives 244, which it should give m
54 for the first column; second one gives 65536.)

Thanks

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