Custom Search
|
Another easy way to loop through a range in Microsoft Excel is to use a For Each...Next loop with the collection of cells specified in the Range property. The macro automatically sets an object variable for the next cell each time the loop runs. The following Microsoft Excel training video describes a procedure that loops through the range B2:B10, setting to 'pink' all values greater than or equal to 9000. |
Custom Search
|