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

manges

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