I've got to eat crow again:

Dave D-C wrote:
Set zRng = Sheets(MySheet).Rows(MyRow)
LastCol = zRng.SpecialCells(xlCellTypeLastCell).Column

does not give the last used column in MyRow.


----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----