Thanks for the reply.

I should have known there would be an indent property for the text, that will come in handy.

I'm not sure the snip of the Excel report was clear enough, what I'm trying to replicate is something like this:

Division1

Dlr1

Dlr2

Division2

Dlr3

Dlr4

Division3

Dlr5

And I can't seem to get past:

Division1

Division2

Division3

Dlr1

Dlr2

Dlr3

Dlr4

How do I get the output without having to resort to something like this (which I know I can do for this report, but will not work nearly as well for others I know I have to convert in the future:

Dlr1

Division1 Dlr2

Dlr3

Dlr4

Division2 Dlr5

Dlr6

I don't need the Division line to hold any detail data, if that makes a difference ...

[Edit] Argh. The formatting (indenting) I was trying doesn't seem to have worked. I hope it still makes sense.