Place the value (result) of a formula into a cell rather than the formula.

 

Sub GetSum()                    ' using the shortcut approach
    [A1].Value = Application.Sum([E1:E15])
End Sub

1.	Define a string type variable and set to Cell(1,D)
2.	StrConv("ALL LOWERCASE ", vbLowerCase)
3.	Format("ALL LOWERCASE ", "<")
4.	Checks values in a range 10 rows by 5 columns
5.	Checks values in a range 10 rows by 5 columns with nested for loop
6.	Validation with a Spreadsheet Cell
7.	Assing value in Cells to array, do the bubble sort and assign them back
8.	transposes the values of a group of cells in a worksheet
9.	Determining a cell's data type
10.	Calculate cell

Place the value (result) of a formula into a cell rather than the formula. : Cell Value « Excel « VBA / Excel / Access / Word