Looping through rows
I'm sorry if this is a very basic question, but I am just getting to grips with writing my own macros in Excel.
I want the macro to run through column b and if column b = "Divn Totals" to then make everything on that row from column b to column ae bold and shaded in light grey.
The code I have done does this, but only for row 7.
If [b7] = "Divn Totals" Then
Selection.Font.Bold = True
.ColorIndex = 15
.Pattern = xlSolid
Any ideas how I can do this for each row in the spreadsheet? Any help would be much appreciated!