Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create a loop | Excel Discussion (Misc queries) | |||
Is it possible to create variables in a loop.. | Excel Programming | |||
Create an array inside a For...Next loop | Excel Programming | |||
Using Loop to create Array | Excel Programming | |||
How do I create a For loop within a For loop? | Excel Programming |