said by 2kmaro:Rob,
It might be that the syntax of the command changes at level 3? One way I go about seeing proper syntax for commands I'm either unfamiliar with or have just forgotten about is to simply record a macro while doing all of the operations I need to code up later. Then I examine the code generated.
For the level 3 part - is it just "not doing anything" or is it generating an error. Sometimes an error is much more informative than "just doesn't do anything".
Thanks for the reply. After the Excel worksheet is generated, since I have automatic styles enabled in Excel, Excel itself generates RowLevel_3, overriding my RowLevel_3. Their RowLevel_3 style has no formatting what-so-ever.
I'm thinking that RowLevel_3 cannot be changed, but instead is a simple style created by Excel just to differentiate from RowLevel_1 & RowLevel_2.