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