answersLogoWhite

0


Best Answer

Thy this:

Dim SumIt As Long

SumIt = Cells(Rows.Count, "C").End(xlUp).Row + 1

Cells(SumIt, "C").Formula = "=SUM(C1:C" & SumIt - 1 & ")"

User Avatar

Wiki User

14y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you calculate the sum of values in a column in excel using visual basic?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

How do you calculate a loop in visual basic 2010?

For i as integer = 1 to 10 ....... Next i


What is visual basic control?

Visual Basic Controls work on Visual Studio for Visual Basic and Applications that made by Visual Basic.


How do you calculate sum of digit of a given three digit number in visual basic?

simple program


The year of invention of visual basic?

Visual Basic was started in 1991.


Who developed visual basic?

Microsoft is the developer of visual basic


Who invented the visual basic?

Visual Basic was created by a team at Microsoft.


What is the difference between visual basic and visual c?

The programming language: Visual Basic is a BASIC-like (or BASIC-derived) language, Visual C is... well C.


How do you calculate degrees of freedom on excel?

Utilizing the visual basic functions built into excel worksheets you can calculate degrees of freedom. The function call that you use for this is "degrees_freedom".


Is Visual Basic 6.0 compatible with Visual Basic 2005?

No.


Who is the developer of Visual Basic?

Microsoft is the developer of Visual Basic.


When visual basic started?

Visual Basic was started in 1991.


What is the diff between Visual Basic 2005 and Visual Basic dot net?

Visual Basic 2005 is actually a version of VB.NET (v8.0). The latest version (9.0) is Visual Basic 2008.