vba formula 公式的引用

最新推荐文章于 2023-02-22 10:23:05 发布

qunxingw

最新推荐文章于 2023-02-22 10:23:05 发布

阅读量4.8k

点赞数 1

分类专栏： vba 文章标签： vba formula excel

本文链接：https://blog.csdn.net/qunxingw/article/details/83271117

版权

vba 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

Sub ai_insurance()
 
cr = Range("c65536").End(xlUp).Row
 
Set crng = Range(Cells(1, 3), Cells(cr, 3))
 
Dim arr(13) As Integer
     
 For Each c In crng
    Select Case Left(c, 2)
     
        Case "1月"
         arr(1) = c.Row
                   
        Case "2月"
         arr(2) = c.Row
          
         
        Case "3月"
         arr(3) = c.Row
         
          
         Case "4月"
         arr(4) = c.Row
             
             
         Case "5月"
         arr(5) = c.Row
             
             
         Case "6月"
         arr(6) = c.Row
             
             
         Case "7月"
         arr(7) = c.Row
             
            
         Case "8月"
         arr(8) = c.Row
          
         
         Case "9月"
         arr(9) = c.Row
          
          
         Case "10"
         arr(10) = c.Row
          
          
         Case "11"
         arr(11) = c.Row
          
         
          
          
          Case "12"
         arr(12) = c.Row
          
          End Select
         Next
         arr(0) = arr(1) - 5  '固定1月起始行号（？-4）
        begin_m = InputBox("请输入起始月 （1~ 11的数值）")
         
        end_m = InputBox("请输入结束月（大于起始月小于12的数值）")
       
         
        col = 0
        For i = begin_m To end_m 'i是月份，循环每月
            r = 0
            For j = arr(i - 1) + 1 To arr(i) - 1     'j是每月的内容行号
                Cells(cr + 1 + r, 5 + col).Formula = "=d" & (j)
                r = r + 1  '让当月数据每行递增
            Next
            col = col + 1  '让月份增加时列号增加
        Next
 
 
End Sub