Hi Dave,
Sorry for the confusions I am creating...
Here we go:

B7:NOT
B8:NOT
B9:BOLD =outline level1 (grouping row7-8)
B10:NOT
B11:NOT
B12:NOT
B13:BOLD =outline level1 (grouping row10-12)
B14:NOT
B15:BOLD =outline level1 (grouping row14)
B16:NOT
B17:NOT
B18:BOLD =outline level1 (grouping row 16-17)
B19:BOLD = outline level2 (grouping row 7-18)

B20:NOT
B21:BOLD =outline level1 (grouping row20)
B22:NOT
B23:NOT
B24:BOLD = outline level1 (grouping row22-23)
B25:BOLD = outline level2 (grouping row20-24),

Potentially:
B26:BOLD = Outline level3 (grouping row 7-25)

etc etc


Really Hope this makes it clearer Bob,
Sige

Dave Peterson wrote:
Try changing:

If RowDiff 2 Then
to
If RowDiff 1 Then

I'm confused about what the other stuff means.

Maybe you could just give some test data starting with B7:

Bold
not
bold
not
not

(Not too much--just enough to find the trouble spots.)

Sige wrote:

Hi Dave,

Very very nice!!! :o))

It does not "outline" everywhere it is supposed to ...

-The first outline he "forgets"
eg.
Row7:Row9 =not bold
Row 10= bold

-If you have just 1row Not Bold and the next Bold = he misses out the
outline
like Row12 =not bold
row13bold =bold
=this outline he does not set

The second level-outlining gets a bit tangled. It should capture all
first level outlinings above this 2 double cell:

Row7:Row10=Notbold
Row11= bold
=outline1level_a

Row12:Row13=notbold
Row14=Bold
=outline1level_b
row15:row15=bold
=outline2level capturing row7:row14

Hope it makes sense?
Sige

--

Dave Peterson