VBA to perform sum of column values if number of rows and columns are not constant

Hi All

The rows and columns are not constant in my example. So I want to perform the sum of all the columns using VBA. The number of rows and number of columns will always vary.

Please seet attached SampleWB.

Suppose total number of columns are stored in "ColCount" variable and total number of rows are stored in "RowCount" variable.

so if I want to perform sum of all the values in each column then how can this be done?

Please Login or Register  to view this content.

Can anyone please help me to write For loop to perform sum of each column. Thanks

Mant Thanks sktneer. It worked like a charm.