When you recorded the macro by selecting only one row, you must hav
clicked on the menu for putting borders. Here by default excel too
care not to give error. But when you try to use this macro for anothe
one-row range, the macro fails as it cannot find the inside horizanta
element for the range. This is an expected behaviour.

manges

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