sort grouped cells
 

I have a worksheet that has several grouped cells and some non-grouped cells.
I'm trying to sort the visible cells, but my problem I run into using the
sort method in VB is that it sorts the visible cells, but the grouped items
do not follow the visible group cell (i.e. the one that has the + group
button next to it). For some reason, if I try this manually on another
worksheet, it works just fine, but this worksheet it doesn't. Any ideas? Is
it a property I'm missing? Thanks