I have a macro that I'm using in Excel 2003... when a range of cells change the macro checks to see if a picture is assigned to that cell and deletes it and replaces the picture based on the new value. Below is the section of code that I'm using and that is no longer working with Excel 2007. I've searched the help in Excel 2007 and the TopLeftCell functionality seems to still exist but I'm getting a run-time error stating that the 'object doesn't support this property or method'
ActiveSheet.Shapes.SelectAll
For Each sh In Selection.ShapeRange
If sh.TopLeftCell.Address(False, False) = "N" + Trim(LTrim(Str)) Then
sh.Delete
End If
Next
ActiveSheet.Shapes.SelectAll
For Each sh In Selection.ShapeRange
If sh.TopLeftCell.Address(False, False) = "N" + Trim(LTrim(Str)) Then
sh.Delete
End If
Next