(Solved) : Exce Visual Basic Following 1 Write Macro Sum Numbers 3rd Column Spreadsheet Starting 1st Q28780034 . . .
in Exce Visual Basic do the following:
1. Write a macro that will sum up all numbers in the 3rd columnof the spreadsheet starting at the 1st non-empty cell, and goinguntil an empty cell is found (you may assume that each cellcontains a valid number (but should know how to test for this)).Note, these cells are not “Selected”, and you shouldnot use the Selection object. Have the macro placethe resulting sum in cell to the right of the final cell inC (eg, if the last value you added in was in C12,then place the total sum in D12). You should use the “DoWhile/Loop” (or While/Wend loop) construct for this macro.
2. Test your macro with numbers starting in C1, and also withnumbers starting in C4 (empty cells for C1-C3).
thank you !
Expert Answer
Answer to Exce Visual Basic Following 1 Write Macro Sum Numbers 3rd Column Spreadsheet Starting 1st Q28780034 . . .
OR