Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 28
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Create a loop stephenc Excel Discussion (Misc queries) 4 January 12th 09 03:54 PM
Is it possible to create variables in a loop.. shishi Excel Programming 2 February 3rd 06 07:21 PM
Create an array inside a For...Next loop Eric Winegarner[_2_] Excel Programming 3 October 27th 05 12:26 AM
Using Loop to create Array davidm Excel Programming 4 June 15th 05 11:41 AM
How do I create a For loop within a For loop? Linking to specific cells in pivot table Excel Programming 2 January 24th 05 08:05 AM


All times are GMT +1. The time now is 05:05 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"