View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
GaryZ GaryZ is offline
external usenet poster
 
Posts: 7
Default Detecting Row Deletion

An additional note: Column E of the subtotal row always contains "CSR Total:"

"GaryZ" wrote:

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.