Got some new, and hopefully better code, the problem now is, the lastro
thing.


Code
-------------------

Set lastcell = Range("A:A").SpecialCells(xlLastCell)
LastRow = lastcell.Row
MsgBox (LastRow)

-------------------


Is what I do, to tell me what the LastRow is. Debugging only, o
course. The thing is, in a list of 5, LastRow returns 108. I selecte
and deleted all rows from 6-65536, and it still returns 108.

Any ideas how I can get the proper list length returned?

Thanks for the ongoing assistance,

-Bo

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