Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 10-03-2020, 11:11 PM
leeqiang leeqiang is offline How to optimize the data summation code for each row and column in a data rectangle area? Windows 10 How to optimize the data summation code for each row and column in a data rectangle area? Office 2019
Advanced Beginner
How to optimize the data summation code for each row and column in a data rectangle area?
 
Join Date: Aug 2020
Posts: 53
leeqiang is on a distinguished road
Default How to optimize the data summation code for each row and column in a data rectangle area?

How to optimize the data summation code for each row and column in a data rectangle area?
20201004134211.png
The red area is the data. How to summarize the data of each column and each row in the 15th row and the kth column?
Book1.xlsm
How can the following code be optimized?thx
Sub sumtheall()
Dim i, j
Columns("k:k").ClearContents
Rows("15:15").ClearContents
For i = 1 To 10


For j = 1 To 14
Cells(15, i) = Cells(15, i) + Cells(j, i)
Next j
Next i

i = 1
j = 1
Do While Cells(j, i) <> ""
For i = 1 To 10
Cells(j, 11) = Cells(j, 11) + Cells(j, i)
Next i
j = j + 1
i = 1
Loop



End Sub
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Need to copy specific ranges column data as row data from one worksheet to another using excel VBA ganesang Excel Programming 1 03-26-2020 06:18 AM
with different area of blocks, can we arrange automatically in a big rectangle area, Optimally oneeyeevil Excel Programming 0 06-21-2019 03:45 AM
How to optimize the data summation code for each row and column in a data rectangle area? Colored Rectangle in Column eseel Word Tables 4 07-26-2017 06:07 AM
How to convert multiple xml data in xl column to xl data vivekanand.p Excel Programming 0 01-28-2016 08:13 AM
How to optimize the data summation code for each row and column in a data rectangle area? How to edit cell data without changing print area. FIXED print area VictoriaT8 Excel 3 02-22-2013 07:54 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:17 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft