create a loop
Hi,
Although the answer to this question will be utilized in a macro for MS Word
I'm sure (hope) it will work for both Excel and Word.
I have a number of objects selected in Word and have written a macro to
adjust the properties. However, anytime the size is adjusted with multiple
objects selected it takes all the objects, which are on different pages, and
puts them onto one page. This will happen even if you manually adjust the
size of the object.
If I have 3 objects with three different settings what happens is
go to object 1, adjust the first property
go to object 2, adjust the first property
go to object 3 ,adjust the first propery
go to object 1, adjust the second property
go to object 2, adjust the second property
go to object 3 ,adjust the second propery
go to object 1, adjust the third property
go to object 2, adjust the third property
go to object 3 ,adjust the third propery
What I need is
go to object 1, adjust the first, second, third property
go to object 2, adjust the first, second, third property
go to object 3, adjust the first, second, third property
So, I'm thinking that I have to create a loop that will adjust all the
properties of each object one a time. What kind of loop do I need and what is
the syntax?
Hope this all makes sense....
Thanks
|