Because VBA variable
SummedValue = _
Worksheets("Sheet1").Range("A1").Value + _
Worksheets("Sheet2").Range("A1").Value
End Sub
When you record macros, Excel often uses underscores to break long statements into multiple lines.
After you enter an instruction, VBA performs the following actions to improve readability:
It inserts spaces between operators. If you enter Ans=1+2 (without spaces), for example, VBA converts it to
Ans = 1 + 2
It adjusts the case of the letters for keywords, properties, and methods. If you enter the following text: Result=activesheet.range("a1").value=12
VBA converts it to
Result = ActiveSheet.Range("a1").Value = 12
Notice that text within quotation marks (in this case, "a1") is not changed.
names are not case-sensitive, the interpreter by default adjusts the names of all variables with the same letters so that their case matches the case of letters that you most recently typed. For example, if you first specify a variable as myvalue (all lowercase) and then enter the variable as MyValue (mixed case), VBA changes all other occurrences of the variable to MyValue. An exception occurs if you declare the variable with Dim or a similar statement; in this case, the variable name always appears as it was declared.
