Detecting Row Deletion
 

Gary,

At least in XL 2000, you can overline. You can specify it in Format Cells
Borders. There's also an overline button that you can drag onto a
toolbar. Go to Tools Customize Commands Format and find the "Top
Border" button.

The overline will behave the way you want - won't be deleted with the line
above.

hth,

Doug Glancy

"GaryZ" wrote in message
...
To overline a range of cells as in a SubTotal row (such as E13:M13) , I
underline the proper cells in the above row (E12:M12). Strange they have
every kind of border line except a line over the cell, but that's another
story.

The drawback in this approach is that when the user deletes the row above
the "overlined" cells (Row 12), the "overline" is also deleted.

I need a way to detect such a row deletion (deleting the row above the
subtotal), so I may underline the proper cells above the deleted row
(E11:M11) so that the SubTotal row again appears to be overlined.

Thanks,
Gary Z.