excel-vbaRanges 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.