Formatting sub totals

[BowlzyLSH]

Hi again,

I have just recorded a macro but need to tidy some things up on it:

Firstly how do you make bold all the sub totals without having to highlight each one individually?

Also how can I put a border around each sub total including the items it has just sub-totalled?

Thanks

Ian

 

[BowlzyLSH]

The above should be done within the macro