VBA Loops with If,Then and Else Commands

[pinkpanther6666]

Good Evening All,

Im trying to write some vba where i have to generate up to 30 reports from my spreadsheet
But sometimes the value in Cell C5 is 0 and i dont want a report generating for that
the SaveReport Macro basically saves the report as a pdf
My VBA Code is as follows

For A = 1 To 30
If Range("C5").Value >= 1 Then Call SaveReport
Else Next A


What im trying to write is if the Value of C5 is Greater and Equal to 1 then call SaveReport and then Next A


Hope anyone can help


Many Thanks


Steve

 

[Rick Rothstein]

My VBA Code is as follows

For A = 1 To 30
If Range("C5").Value >= 1 Then Call SaveReport
Else Next A

What im trying to write is if the Value of C5 is Greater and Equal to 1 then call SaveReport and then Next A

Write that code this way...

For A = 1 To 30
  If Range("C5").Value >- 1 Then Call SaveReport
Next

 

[V_Malkoti]

Sounds like you don't need Else part.

For A = 1 To 30
	If Range("C5").Value >= 1 Then 
		Call SaveReport
	End If
Next A

 

[Rick Rothstein]

Write that code this way...

For A = 1 To 30
  If Range("C5").Value >- 1 Then Call SaveReport
Next

Sounds like you don't need Else part.

For A = 1 To 30
	If Range("C5").Value >= 1 Then 
		Call SaveReport
	End If
Next A

Just to clarify the difference between the above two codes... there is none except for the format.

For the first code
-----------------------------------
This is the single line form of the If..Then statement. When you only have a single statement to execute when the If condition is True, you can put it on the same line as the If..Then and you do not need an End If to close it off.


For the second code
-----------------------------------
This is the block form of the If..Then statement. When you have more than one statements to execute when the If condition is True, you place them each on their own line underneath the If..Then statement and above an End If statement. You can also use the block form of the If..Then statement for a single line of code to execute when the If condition is True if you want... you have a choice of formats to use (single line or block form) when you only have a single line of code.