VBA: Clear Contents for Multiple Groups of Columns based on Data

[VBA Beginner 2024]

I am trying to use VBA to clear contents of a group of cells in a row based on data in various columns:
Example:

IF Column A or G is Y i want to clear contents of B to F or H to L respectively.
I have the following using different columns but for example in row 3, it would delete data in B to F instead of H to L.

Dim lr As Long, i As Long
lr = Cells(Rows.Count, "X").End(xlUp).Row
For i = 2 To lr
If UCase(Cells(i, "X")) = "Y" Then Cells(i, "Y").Resize(1, 5).ClearContents
Next i
lr = Cells(Rows.Count, "AC").End(xlUp).Row
For i = 2 To ls
If UCase(Cells(i, "AC")) = "Y" Then Cells(i, "Y").Resize(1, 5).ClearContents
Next i

How would i write the second part to focus on 2nd set of columns vs the first?

 

[Coyotex3]

Hmmm, so if I understand this correctly, if Column A is Y then clear content on columns H:L but if Column G is Y then clear content on columns B:F? Is that accurate?

 

[VBA Beginner 2024]

nevermind figured it out haha

 

[VBA Beginner 2024]

Hmmm, so if I understand this correctly, if Column A is Y then clear content on columns H:L but if Column G is Y then clear content on columns B:F? Is that accurate?

yeah i forgot to change the second Y to the starting point of the next deleted columns. Thank you for replying!