excel-vba Ranges and Cells


  • 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


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.