ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   create a loop (https://www.excelbanter.com/excel-programming/359155-create-loop.html)

Ivano

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