excel-vba Ranges and Cells
Syntax
- Set - The operator used to set a reference to an object, such as a Range
- For Each - The operator used to loop through every item in a collection
Remarks
Note that the variable names r, cell and others can be named however you like but should be named appropriately so the code is easier to understand for you and others.
