Thread: [Solved] Macro is manipulating item in wrong section even though variable watch says it should be right
View Single Post
 
Old 12-05-2022, 04:10 PM
macropod's Avatar
macropod macropod is offline Windows 10 Office 2016
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Quote:
Originally Posted by Guessed View Post
In my experience with floating shapes in the headers, VBA seems to think all the shapes are in every section even though the user interface shows a graphic only in one sections header. This can be further complicated when some headers may have 'Link to Previous' turned on.

So I have no faith at all in being able to use VBA to determine which shape you are referring to via the section number.
To do that, you need to get the header index and check backwards through that Section and each preceding Section to determine where the .LinkToPrevious attribute (if applied to the current Section) ends. That Section is the one in which the shape actually exists.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote