|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
|
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 |
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 edit cell data without changing print area. FIXED print area | VictoriaT8 | Excel | 3 | 02-22-2013 07:54 PM |