【2】VBAFor-next循环语句for-next 3/ExcelVBA流程图解之,For循环的本质原来系统偷偷干了很多事 https://learning./feoffline/toutiao_wallet_bundles/toutiao_learning_wap/online/article.html?item_id=6791320887317496323&app_name=news_article 2)/https://zhidao.baidu.com/question/1888119942888706708.html For i = 1 To Worksheets.Count If Worksheets(i).Name = "目录" Then Exit For End If Next 1)VBA中for循环语句的用法 http://www.360kuai.com/pc/982c5eb08c5b7ab73?cota=4&kuai_so=1&tj_url=xz&sign=360_57c3bbd1&refer_scene=so_1 语法: for i=初始值 to 结束值 step 步长值 …… Exit For '中途退出for循环 .... next --- czm) Sub yb日期宏find() hym1 = "1a/2019-05" name1 = "销售收入" name2 = "产品产量" n = 0 For n = 0 To 2 Step 0 'step 0时,一个循环n加上1;如step 0时,一个循环n加上2; n = n + 1 MsgBox n Name = "name" & n MsgBox Name dz = "dz" & n MsgBox dz 'Set dz = Sheets(s).Range("A1:A60").Find(Name) 'If Not dz Is Nothing Then 'b = Rng.Row 'End If Next End Sub 【】 |
|
来自: c857084163 > 《Excel》