Loop selected range macro in Excel

We are going to walk you through one approach to loop through a selected range of data using a macro in Excel VBA. We have budget EBITDA financial data for a list of business units.

The For Each cell In rng syntax is the critical piece of code, which will enable us to loop through our selected range of financial data. To demonstrate this looping macro, we will insert a simple If statement, which will bolden cell values that are greater than zero, or else italicize the value if equal to or less than zero.