Hi,

I need to sum up the total value in each column to put into a value in another worksheet.

I am using a for each loop to loop through each column,

May I know how do I code it to sum the values from column D2 to last rowthat contains a value in that column.

I need to do a sum for each row, I need to find the total of those values
For example
D2:D10
E2:E15
F2:F4



Thanks