loop a specific number of occurrences
 

Typically, one would use a For loop, not a Do loop, in this
circumstance. E.g.,

Dim N As Long
For N = 1 To 10
' do something
Next N

However, if you do want a Do loop, use

N = 0
Do Until N = 10
' do something
N = N + 1
Loop

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Fri, 14 Aug 2009 11:02:03 -0700, paularo
wrote:

How do I get a "do loop" to run a specific number of times then stop?

Thanks.