![]() |
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 |
All times are GMT +1. The time now is 05:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com