listi.net

Excel VBA - $ Dollar sign (7)

1.
Used for Absolute Cell reference
2.
$A5 - When copying use Column A
3.
A$5 - When copying use row 5
4.
$A$5 - When copying use A5
5.
A5 - When copying use relative cells
6.
String Variable type (ex. Dim aString$ )
7.
Formatting character

	1.	Used for Absolute Cell reference
	2.	$A5 - When copying use Column A
	3.	A$5 - When copying use row 5
	4.	$A$5 - When copying use A5
	5.	A5 - When copying use relative cells
	6.	String Variable type (ex. Dim aString$ )
	7.	Formatting character