Excel-VBA Named range row sum

I have the following code For i = 1 To DepRng.Rows.Count For j = 1 To DepRng.Columns.Count DepRng.Cells(i, j) = Application.Sum(KidsRng.Row(i)) //Does not work Next j Next i Although I know is wrong, i have no idea how to get it to store in `DepRng.Cells(i, j)` the total sum of the whole `KidsRng.Row[i]` Any help?
Can you add in a definition of KidsRng ?

以上就是Excel-VBA Named range row sum的详细内容,更多请关注web前端其它相关文章!

赞(0) 打赏
未经允许不得转载:web前端首页 » excel

评论 抢沙发

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址

前端开发相关广告投放 更专业 更精准