Rows Count of a particular column

K

kaon

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.Count
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
 
M

mudraker

kaon


Worksheets("Settings").UsedRange.Columns(1).Rows.Count

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
 
N

Norman Jones

Hi Mudraker,

This is not correct,
Worksheets("Settings").UsedRange.Columns(1).Rows.Count
Click to expand...

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