shmilyjoy的博客

原创 VBA学习记录一

1、for循环 dim i as integer for i = 10 to 1 step -1 ... next 2、for each循环 dim r as range/worksheet for each r in range("a1:a10")/sheets ... next 2、range表示单元格： range(“a”& i)、sheet1.range(“a1”) 3、IF语句 用if判断是否退出for循环，关键字：exit for If...Then Elseif...Then