Moving to Excel 2010 and line of code causing issues (ungrohp)

Hi. Not sure if this is going to be enough to go by but this...

Set sr = myChart.Shapes(count + 1).ungroup
Set SecondBox = sr(2)
Set FirstBox = sr(1)

Where the two variables are Excel.Shape

The above works perfectly in prior versions of Excel but now longer work. I'm not familiar with vba and this line of code, specifically the first, is holding up the upgrade. Is there any way to rewrite it so that it would work in 2010?

Thanks! How would that work with the next two lines? The first and second variables are used for formatting the shapes

Hey Andy. I just didn't know how it followed through. I thought the way you had it originally was the way it needed to be. Thank you! I will give this a shot in a little bit and report back