How to optimize the data summation code for each row and column in a data rectangle area?

		Microsoft Office Forums > Microsoft Excel > Excel Programming
How to optimize the data summation code for each row and column in a data rectangle area?

FAQ

Thread Tools

Display Modes

10-04-2020, 02:33 AM

Purfleet

Windows 10 How to optimize the data summation code for each row and column in a data rectangle area?

Office 2019

Expert

Join Date: Jun 2020

Location: Essex

Posts: 345

As long as the rows and columns are static, you just need to do a sum formula in the range without the fixed references

Sub sumtheall()

Columns("k:k").ClearContents
Rows("15:15").ClearContents

Range("a15:j15") = "=sum(a1:a14)"
Range("k1:k14") = "=Sum(a1:j1)"

End Sub

Last edited by Purfleet; 10-04-2020 at 02:36 AM. Reason: typo

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