MsgBox Cells(1, Columns.Count).End(xlToLeft).Column

don't forget when using cells command use numbers without ""

cells(row number,column number)

or
cells(row number, "column letter")


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/