Visual Basic Help

Reply #4

AllenB — Sun, 01 May 2016 22:21:12 GMT

Thanks, that looks like what I am Looking for

And Mone! thanks for showing me the reference library

Reply #3

phileight — Sun, 01 May 2016 10:26:11 GMT

the basic for next loop works for this. there are other methods.

within your macro

for x=1 to 50' use any valid variable name and value that you want here

your code as many lines as you need

next x' if you used x in the for statement you must use x in the next statement. x cannot be used in your code. x can be any valid variable name

that works great if you have a fixed number of loops. the values can be variables. ex

bgn=1:en_d=50

for x=bgn to en_d

code

next x... [ More ]

Reply #2

MonEl — Sun, 01 May 2016 09:27:37 GMT

Seems to me that you are in the wrong Web site to ask for such.

And that also my posting this is a waste of my time.

https://msdn.microsoft.com/en-us/library/5z06z1kb.aspx

http://www.wiseowl.co.uk/blog/s193/vba-for-next.htm

http://www.fontstuff.com/ebooks/free/fscodeloops.pdf

http://www.classanytime.com/mis333k/sjloopsarrays.html

http://www.vb6.us/tutorials/understanding-do-and-while-loops

http://academic2.strose.edu/math_and_science/avitabij/cis321/vba/vb1.htm

https://ms... [ More ]

Reply #1

Todd — Sat, 30 Apr 2016 19:31:42 GMT

Visual Basic Help

AllenB — Sat, 30 Apr 2016 16:14:45 GMT

When it comes to Macros, I am a step-cut-paste creator. I need to learn. I need a simple counter in a macro that will run an application a specified number of times.

Pretty basic, I would look it up; but, my brain is fried from the Step-Cut-Paste Shuffle.

Thanks