Foxtable(狐表)用户栏目专家坐堂 → 帮忙看下代码对不对...


  共有2357人关注过本帖树形打印复制链接

主题:帮忙看下代码对不对...

帅哥哟,离线,有人找我吗?
有点甜
  1楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:版主 帖子:85326 积分:427815 威望:0 精华:5 注册:2012/10/18 22:13:00
  发帖心情 Post By:2018/3/30 12:12:00 [显示全部帖子]

With Tables("发货清单记录")
    If .TopPosition > -1 Then '如果选定区域包括数据行
        For i As Integer = .TopPosition+1 To .BottomPosition
            Dim A As Double = CDbl(.rows(i-1)("出厂编号").Substring(1, 7))
            Dim n1 As Double = .rows(i-1)("发货数量")
            Dim n2 As Double = .rows(i)("发货数量")
            Dim B As String = Cstr(A+n1)
            Dim B1 As String = Cstr(A+n1+n2-1)
            .rows(i)("出厂编号") = B & "-" & B1
        Next              
    End If
End With

 回到顶部