Struggling with what, in other posts, appears to be simple. I have columns A:K grouped. I am then running the following line of code to determine what outline level is currently being displayed.
Whether the group is expanded or not, this always returns 2. When it is collapsed it does not return 1. I have verified that columns outside of the group return a 1. I thought the fact that there are some activex controls on the worksheet might be causing problems. However I added a blank worksheet and tested the same code and received the same results. If it helps I am using MS Office Standard 2010. As usually I am sure I am missing something obvious so apologies for that. And as always any help is greatly appreciated!!