View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Teak[_2_] Teak[_2_] is offline
external usenet poster
 
Posts: 3
Default Search for subtotals

I wld like to start at cell D3. Then search for any subtotals downwards.
If found, say cell D15, outline the upper border (ie btw D14 & D15),
and insert a line below D15 (I find this difficult becos inserted line is
always above, not below)

This should continue until end of data rows.

Thanks.