How do you use a macro to format subtotal rows?

[Sudheerp]

Is it possible to select all the subtotal rows and columns using a macro.. for example the code below is in the macro to show the excel sheet only from level 2 or only the subtotals.

Please Login or Register  to view this content.

Is there a way to select RowLevel 2 cells and format? Any help would be awesome!

[VBA Noob]

Hi,

I record this. See if it helps

Non VBA way

http://www.exceltip.com/st/Applying_...Excel/270.html

Please Login or Register  to view this content.

VBA Noob