cool hit counter ExcelVBA Basic Tutorial - Loop_Intefrankly

ExcelVBA Basic Tutorial - Loop


Sub procedure name()

i = 1
s = 0 'The initial value is0 may be omitted

While i <= 100
    s = s + i
    i = i + 1
Wend

Do While i <= 100
    s = s + i
    i = i + 1
Loop

Do ' First unconditional implementation
    s = s + i
    i = i + 1
Loop While i <= 100

Do
    s = s + i
    i = i + 1
Loop Until i > 100

Do
    s = s + i
    i = i + 1
    If i > 100 Then Exit Do
Loop

For i = 1 To 100
    s = s + i
Next

For Each sh In Sheets
    sh.[A1] = sh.Name
Next

End Sub


Recommended>>
1、Internet government era the governments big data security as thin ice
2、Single signon example using php detailed
3、What are the prospects for Cloud Operations and Maintenance Engineers
4、White Talk Smart Manufacturing 3 What is Smart Manufacturing
5、BIT GAME and GMGC cohost Global Blockchain Gaming Forum

    已推荐到看一看 和朋友分享想法
    最多200字,当前共 发送

    已发送

    朋友将在看一看看到

    确定
    分享你的想法...
    取消

    分享想法到看一看

    确定
    最多200字,当前共

    发送中

    网络异常,请稍后重试

    微信扫一扫
    关注该公众号