how does vba know to do nothing

[kylefoley76]

i got this code from mrexcel live lessons ch 31. in it there is a line that says

if this dept = lastdept then
' do nothing

well, how does vba know to do nothing? there is no command after the "then" statement. here is a screen shot of the full code

 

[Ragnar1211]

Because there is no command after the "then" statement, excel will literally do nothing. The commented part 'do nothing' is just FYI.

 

[kylefoley76]

thanks ragnar, that makes sense.

 

[Scott Huish]

That structure however is strange instead of Then Do Nothing, change the condition to

If ThisDept <> LastDept Then
LastRow = i - 1
'etc
End If


and drop the Else

 

[Norie]

HOTPEPPER

I can kind of see what you mean but I think having a comment like that, if in the right place, can actually help.

Mind you I suppose it could be a little confusing if overused.

 

[Scott Huish]

I think it's just adding lines of code. If you're not going to use Then, then just change it to a condition that doesn't require Else.

It would be the same situation if you didn't need an Else but included it to say do nothing.