Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » For and Next loops

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

For and Next loops

Resolved · Low Priority · Version 2007

Reply Fri 12 Jun 2009, 16:18Delegate Tracey said...

Tracey has attended:
Excel Advanced course
Excel VBA Intro Intermediate course

For and Next loops

Hi

We have done a lot of For and Next loops where the looping variable is a series of numbers, eg:

For intName = 1 to 10

Can you set up this looping with non-sequential numbers, or with text? Or can you refer to a list in another location?

eg For dateMonth=Jan,Feb,Mar etc

eg For strName=each of the values on rows 2 to 8 in column 3 on the sheet "List page"?

Thanks

Tracey

For upcoming training course dates see: Pricing & availability

Reply Wed 17 Jun 2009, 13:53Trainer Simon said...

RE: For and Next loops

Hi Tracey,

Thank you for your question.

Here is a line of code that will allow non sequential numbers:

For I = 0 to 100 step 2 - step 2 meaning every other number

On the advanced course we cover this and we also cover arrays which may help you.

I hope this has answered your question.

Regards,

Simon

Tue 23 Jun 2009: Automatically marked as resolved.

Excel articles

· Excel 2010 A Glance Into The Future
· How To Disguise Error Messages In Excel 2007/2010
· How To Use Excel To Create Large SQL Insert Statements
· Making The Most Of Filtering In Excel
· 5 Microsoft Excel Charts for Creating Stunning Business Documents

Please browse our web site to find out more about
excel training courses and other Microsoft training courses.

Excel tip:

Brighten up your Excel 2010 Spreadsheet by changing the colours of the gridlines

Excel 2010 allows you to change the colour of grid lines instead of keeping them in boring black.

Select the File tab on the Ribbon, click Options, click Advanced, scroll down to ''Display options for this worksheet.'' Next to ''Gridline colour,'' choose your favourite colour, then once you've done this, click OK. Easy!

View all Excel hints and tips