Visual Basic Programming
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me

The Shed is going Social! Join us on FaceBook and Twitter and chime in on the conversation.

Go Back   Dev Shed Forums > Programming Languages - More > Visual Basic Programming
Reload this Page

For loop question


Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old March 7th, 2012, 07:04 PM
Ranakhu Ranakhu is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Jan 2009
Posts: 65 Ranakhu User rank is Sergeant (500 - 2000 Reputation Level)Ranakhu User rank is Sergeant (500 - 2000 Reputation Level)Ranakhu User rank is Sergeant (500 - 2000 Reputation Level)Ranakhu User rank is Sergeant (500 - 2000 Reputation Level)Ranakhu User rank is Sergeant (500 - 2000 Reputation Level) 
Time spent in forums: 13 h 36 m 42 sec
Reputation Power: 14
For loop question
Below is my For loop but I "Unexpected Next" error.

Code:
	For iPinRow = iPinNameRow+2 To usedRowsCount+1
	
		If iPinRow.Value = "" Then
			Next
		Else
                        ' do something
                End If
 
        Next


What am I doing wrong - any ideas?
Reply With Quote
  #2  
Old March 7th, 2012, 10:44 PM
Doug G Doug G is offline
Grumpier Old Moderator
Dev Shed God 19th Plane (14000 - 14499 posts)
  
Join Date: Jun 2003
Posts: 14,237 Doug G User rank is General 52nd Grade (Above 100000 Reputation Level)Doug G User rank is General 52nd Grade (Above 100000 Reputation Level)Doug G User rank is General 52nd Grade (Above 100000 Reputation Level)Doug G User rank is General 52nd Grade (Above 100000 Reputation Level)Doug G User rank is General 52nd Grade (Above 100000 Reputation Level)Doug G User rank is General 52nd Grade (Above 100000 Reputation Level)Doug G User rank is General 52nd Grade (Above 100000 Reputation Level)Doug G User rank is General 52nd Grade (Above 100000 Reputation Level)Doug G User rank is General 52nd Grade (Above 100000 Reputation Level)Doug G User rank is General 52nd Grade (Above 100000 Reputation Level)Doug G User rank is General 52nd Grade (Above 100000 Reputation Level)Doug G User rank is General 52nd Grade (Above 100000 Reputation Level)Doug G User rank is General 52nd Grade (Above 100000 Reputation Level)Doug G User rank is General 52nd Grade (Above 100000 Reputation Level)Doug G User rank is General 52nd Grade (Above 100000 Reputation Level)Doug G User rank is General 52nd Grade (Above 100000 Reputation Level) 
Time spent in forums: 1 Month 4 Weeks 14 h 43 m 55 sec
Reputation Power: 4445
Get rid of the embedded next statement in the if. Just comment it out and your loop should work the way you want.
__________________
======
Doug G
======
It is a truism of American politics that no man who can win an election deserves to. --Trevanian, from the novel Shibumi
Reply With Quote
  #3  
Old March 7th, 2012, 11:31 PM
Ranakhu Ranakhu is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Jan 2009
Posts: 65 Ranakhu User rank is Sergeant (500 - 2000 Reputation Level)Ranakhu User rank is Sergeant (500 - 2000 Reputation Level)Ranakhu User rank is Sergeant (500 - 2000 Reputation Level)Ranakhu User rank is Sergeant (500 - 2000 Reputation Level)Ranakhu User rank is Sergeant (500 - 2000 Reputation Level) 
Time spent in forums: 13 h 36 m 42 sec
Reputation Power: 14
Thanks Doug,

Actually, I wanted to know how to go the next iteration in the For loop (I am more used to Perl than VB so tried Next for the next iteration) - since there's no such thing as Next in VB, I used an IF statement for not equal and problem solved.

Regards,
Reply With Quote
  #4  
Old March 8th, 2012, 11:08 AM
medialint's Avatar
medialint medialint is offline
Type Cast Exception
Dev Shed God 20th Plane (14500 - 14999 posts)
  
Join Date: Apr 2004
Location: OAKLAND CA | Adam's Point (Fairyland)
Posts: 14,938 medialint User rank is General 112nd Grade (Above 100000 Reputation Level)medialint User rank is General 112nd Grade (Above 100000 Reputation Level)medialint User rank is General 112nd Grade (Above 100000 Reputation Level)medialint User rank is General 112nd Grade (Above 100000 Reputation Level)medialint User rank is General 112nd Grade (Above 100000 Reputation Level)medialint User rank is General 112nd Grade (Above 100000 Reputation Level)medialint User rank is General 112nd Grade (Above 100000 Reputation Level)medialint User rank is General 112nd Grade (Above 100000 Reputation Level)medialint User rank is General 112nd Grade (Above 100000 Reputation Level)medialint User rank is General 112nd Grade (Above 100000 Reputation Level)medialint User rank is General 112nd Grade (Above 100000 Reputation Level)medialint User rank is General 112nd Grade (Above 100000 Reputation Level)medialint User rank is General 112nd Grade (Above 100000 Reputation Level)medialint User rank is General 112nd Grade (Above 100000 Reputation Level)medialint User rank is General 112nd Grade (Above 100000 Reputation Level)medialint User rank is General 112nd Grade (Above 100000 Reputation Level)  Folding Points: 319635 Folding Title: Super Ultimate Folder - Level 1Folding Points: 319635 Folding Title: Super Ultimate Folder - Level 1Folding Points: 319635 Folding Title: Super Ultimate Folder - Level 1Folding Points: 319635 Folding Title: Super Ultimate Folder - Level 1Folding Points: 319635 Folding Title: Super Ultimate Folder - Level 1Folding Points: 319635 Folding Title: Super Ultimate Folder - Level 1
Time spent in forums: 6 Months 2 Weeks 2 Days 19 m 8 sec
Reputation Power: 8490
Facebook
There is a Next of course you just can't put it in the middle of an If logic block.

There is an Exit For if you wanted to break out of the loop altogether.

example..

Code:
Sub TestFor()
    Dim n As Integer
    For n = 0 To 100
        If n Mod 13 = 12 Then
            Exit For
        End If
    Next
End Sub


VB also still has a GOTO but I've never encountered a use for it (except error handling) where the same thing couldn't be done with if/then or other logic.
__________________
medialint.com

“Today you are You, that is truer than true. There is no one alive who is Youer than You.” - Dr. Seuss
Reply With Quote
Reply

Viewing: Dev Shed Forums > Programming Languages - More > Visual Basic Programming > For loop question

« Previous Thread | Next Thread »

Developer Shed Advertisers and Affiliates



Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 


Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.

© 2003-2013 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap