I just tested, but not selected one line and have no proble. But if you select one line or column, you must not use:
.borders(xlInsideVertical)
or
.borders(xlInsideHorizontal)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.