I'm trying to figure out how to select a range of cells in each row based on information presented in column A of that row.
I've inserted a file to help explain what I need.

Test Workbook.xlsm

I would like the macro to, for each row in the worksheet, see if column 1 has a "Yes"; if so select the "info" cells in columns labeled "Heading 5" through "Heading 9", then switch the text color to the same color as the background so that those cells appear empty.

I've attached my (non-operational) code below:

Sub Whiteout()

For Each Row In Range("A15:J200")
If Column("A:A").Value = "Yes" Then Range(Cells(F), Cells("J")).Select = True
    With Selection.Font
        .ThemeColor = xlThemeColorDark1
        .TintAndShade = 0
    End With
Next Row

End Sub
The other thing I was hoping to do would be to add in a count/last row function as the number of rows will constantly be changing and I don't need it to search all the way to row number 200.

This all seemed like it should be fairly simple to do but I am definitely still a self-taught beginner with VBA and haven't been able to, after hours and hours of searching forums and help sections, to get this figured out. Any help would be greatly appreciated!