Inserts a formula in cell A11 of a worksheet that calculates the sum of the values in the range A2:A10 using the Excel application's SUM function : Formula « Excel « VBA / Excel / Access / Word

VBA / Excel / Access / Word

1.	Access
2.	Application
3.	Data Type
4.	Data Type Functions
5.	Date Functions
6.	Excel
7.	File Path
8.	Forms
9.	Language Basics
10.	Math Functions
11.	Outlook
12.	PowerPoint
13.	String Functions
14.	Windows API
15.	Word
16.	XML

Java

Java Tutorial

Java Source Code / Java Documentation

Illustrator Tutorials

GIMP Tutorials

C# / C Sharp

C# / CSharp Tutorial

C# / CSharp Open Source

SQL Server / T-SQL Tutorial

Oracle PL / SQL

Oracle PL/SQL Tutorial

Flash / Flex / ActionScript

XML

XML Tutorial

Microsoft Office PowerPoint 2007 Tutorial

Microsoft Office Excel 2007 Tutorial

Microsoft Office Word 2007 Tutorial

VBA / Excel / Access / Word » Excel » Formula

Inserts a formula in cell A11 of a worksheet that calculates the sum of the values in the range A2:A10 using the Excel application's SUM function


 

Sub formal()

    Dim formulaString As String

    formulaString = "=SUM($A$2:$A$10)"

    Cells(11, "A").Formula = formulaString

End Sub

Related examples in the same category

1.	Fill formula to cell
2.	Use [] to evaluate formula
3.	Is active cell empty
4.	Two ways you can use Evaluate to generate a reference to a Range object, and assign a value to that object
5.	The Evaluate method can also be used with arrays.
6.	Assigns the values 101 to 200 to the range B1:B100, and again does it more efficiently than a For...Next loop
7.	Use Copy and Paste or AutoFill functions
8.	Create a set of related formulas in a column: use a looping structure to iterate through the cells that receive the formula

www.java2java.com | Contact Us

All other trademarks are property of their respective owners.