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

kaon


Worksheets("Settings").UsedRange.Columns(1).Rows.C ount

works ok

your result indicates that a244 has an entry in it - possible a space

One way to check is to goto a65536 then press the ctrl & up arrow key
to see what cell is highlighte

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

Hi Mudraker,

This is not correct,

Worksheets("Settings").UsedRange.Columns(1).Rows.C ount

will return the row of the last used cell in the worksheet, not the last
cell in column A.


---
Regards,
Norman


"mudraker " wrote in message
...
kaon


Worksheets("Settings").UsedRange.Columns(1).Rows.C ount

works ok

your result indicates that a244 has an entry in it - possible a space

One way to check is to goto a65536 then press the ctrl & up arrow keys
to see what cell is highlighted


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