Wildcard Characters

[Matt]

Just a quick one, I want to capture occurences where the counter is = 100,200,300....2,200, basically when the number ends in 00. Using an IF statement in VBA, is there a wildcard I can use (counter is an integer variable), e.g. #00.

Hope someone can help.

Thanks

Matt

 

[Andrew Poulsom]

You can use the Mod operator like this:

If x Mod 100 = 0 Then
'   Do your stuff
End If

 

[Matt]

Thanks Andrew