Block IF? (VBA excel 2003/2007)

[Epic786]

Well I am running some code and it keeps saying block if!
how do u make a block if function cus i cant seem to correct it
thx for ur help in advance

 

[p45cal]

A snippet of your code would be useful…

 

[Epic786]

If number = 0 Then Stars = ""
End If
If number = 1 Then Stars = "*"
End If
If number = 2 Then Stars = "**"
End If
If number = 3 Then Stars = "***"
End If
If number = 4 Then Stars = "****"
End If
If number = 5 Then Stars = "*****"
End If

 

[Epic786]

Well I am running some code and it keeps saying block if!
how do u make a block if function cus i cant seem to correct it
thx for ur help in advance

If number = 0 Then Stars = ""
End If
If number = 1 Then Stars = "*"
End If
If number = 2 Then Stars = "**"
End If
If number = 3 Then Stars = "***"
End If
If number = 4 Then Stars = "****"
End If
If number = 5 Then Stars = "*****"
End If

 

[ukmikeb]

Hi

Try :-

Stars = Application.WorksheetFunction.Rept("*", number)

hth

 

[Epic786]

thx bro will do

 

[ukmikeb]

Hi

You're welcome.

Good luck with your project.

ps It was reporting the Block If because the "End If" was superfluous as the "If ..Then" was a one-liner.