L
Legacy 356664
Guest
Hi there,
I am trying to retrieve the formula from all linked pictures so that I can turn on/off updates using defined names.
This is working fine, except for when the linked picture is part of a group.
I have tried
For Each Pic In ActiveSheet.Pictures
Select Case Pic.Type
Case msoGroup
For groupIndex = 1 To Pic.GroupItems.Count
array(x) = Pic.GroupItems(groupIndex).Formula
x = x + 1
Next groupIndex
End Select
Next Pic
But this returns an empty string (in arr(x))
Any suggestions? Thanks for your help
I am trying to retrieve the formula from all linked pictures so that I can turn on/off updates using defined names.
This is working fine, except for when the linked picture is part of a group.
I have tried
For Each Pic In ActiveSheet.Pictures
Select Case Pic.Type
Case msoGroup
For groupIndex = 1 To Pic.GroupItems.Count
array(x) = Pic.GroupItems(groupIndex).Formula
x = x + 1
Next groupIndex
End Select
Next Pic
But this returns an empty string (in arr(x))
Any suggestions? Thanks for your help