Get Addition of each Column in a sheet

  • Thread starter Thread starter Ahmad Jalil Qarshi
  • Start date Start date
A

Ahmad Jalil Qarshi

hi!

i hava a sheet. I don't know how many cells in each column of the sheet are
filled with numeric data. I just want to Get the addition of each column of
sheet using VBA.

Any Ideas,

Thanks in advance.

Ahmad Jalil Qarshi
 
assume the data is from A1 down
the code will be something like this

==========
MsgBox WorksheetFunction.Sum(Range(Range("a1"), Range("a1").End(xlDown)))

======================
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel A CountIF question... I think 2
Copy columns and paste with blank column between 5
Search other sheets for numbers & color them 10
Modifying Last Few bytes of a file 1
Counting used cells on sheet 3
Progressive number in different sheets 7
Advice on multiple macros, same code just a different column 9
Find a value in a sheet and replace it with another value if it matches 8

Back
Top