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/