Making Groups in 'For Each' loop

howiechiang · Feb 27, 2014

I am compiling a list of BOMs. It will first list the assembly name, and then list all of it's components in the rows underneath.

The assemblies name and fields pulled with it must be bold. The list of components underneath it must be group together, so i can collapse all the groups and just see the assemblies.

In my code, the "For Each oAssembly In oAssemblies" it pulls assembly p/n, quantity, and description. The "For Each oCell In oQuantity" nested in that loop pulls the information of individual piece parts in that assembly.

Please help.

Code:

Public Sub SortBOM()


Dim oAssembliesRow As Range
Dim oAssemblies As Range
Dim oBOM As Range
Dim oPieceParts As Range
Dim oQuantity As Range
Dim oCell As Range
Dim oAssembly As Range




'Delete current BOM sheet and create a new'
For Each ws In ThisWorkbook.Sheets
    If ws.Name = "BOM" Then
        ws.Delete
    End If
Next
Sheets.Add.Name = "BOM"




'Select cells to check for quantity & location to store that information'
Set oAssembliesRow = ThisWorkbook.Worksheets("Parts Count").Range("D4:CC4")


Set oBOM = Worksheets("BOM").Range("A1")
Set oAssemblies = oAssembliesRow.SpecialCells(xlCellTypeConstants)




'Input the title of fields in oBOM sheet'
oBOM.Value = "Assemblies"
oBOM.Offset(0, 1).Value = "Piece Part"
oBOM.Offset(0, 2).Value = "Revision"
oBOM.Offset(0, 3).Value = "Quantity"
oBOM.Offset(0, 4).Value = "Description"


'Create'
For Each oAssembly In oAssemblies
    Worksheets("Parts Count").Activate
    
    Set oPieceParts = Range(Cells(7, oAssemblies.Column), Cells(Rows.Count, oAssemblies.Column))
    Set oQuantity = oPieceParts.SpecialCells(xlCellTypeConstants)
    oPieceParts.SpecialCells(xlCellTypeConstants).Activate
    
    oBOM.Offset(1, 0).Value = Worksheets("Parts Count").Cells(6, oAssemblies.Column).Value
    oBOM.Offset(1, 3).Value = Worksheets("Parts Count").Cells(4, oAssemblies.Column).Value
    oBOM.Offset(1, 4).Value = Worksheets("Parts Count").Cells(5, oAssemblies.Column).Value
    
    Set oBOM = oBOM.Offset(1, 0)
    Worksheets("BOM").Activate


            For Each oCell In oQuantity
                Set oBOM = oBOM.Offset(1, 0)
                oBOM.Offset(0, 1).Value = Worksheets("Parts Count").Cells(oCell.Row, 2).Value
                oBOM.Offset(0, 2).Value = Worksheets("Parts Count").Cells(oCell.Row, 3).Value
                oBOM.Offset(0, 3).Value = Worksheets("Parts Count").Cells(oCell.Row, oQuantity.Column).Value
                oBOM.Offset(0, 4).Value = Worksheets("Parts Count").Cells(oCell.Row, 1).Value
        
            Next oCell




Next oAssembly


End Sub

Worf · Mar 2, 2014

Hello
I'm not sure if I'm understanding the layout of the "Parts Count" sheet. Could you post a partial view of it using Excel Jeanie, or upload it to a hosting site?

howiechiang · Mar 3, 2014

There are rows for all components, and each column represents a different assembly. If the assembly contains a piece part, it will have the number used on the assembly in that row. It's sensitive materials so I cannot.

Worf · Mar 3, 2014

I don't need the actual data, just the layout. To write code we must know the exact location of the items on the sheet.
I'm assuming your current code does not work properly, because I ran it on this sample data:

Parts Count

*

A

B

C

D

E

F

G

H

I

J

K

L

<tbody>
[TD="bgcolor: #cacaca, align: center"]1[/TD]
[TD="align: center"]A1[/TD]
[TD="align: center"]B1[/TD]
[TD="align: center"]C1[/TD]
[TD="align: center"]D1[/TD]
[TD="align: center"]E1[/TD]
[TD="align: center"]F1[/TD]
[TD="align: center"]G1[/TD]
[TD="align: center"]H1[/TD]
[TD="align: center"]I1[/TD]
[TD="align: center"]J1[/TD]
[TD="align: center"]K1[/TD]
[TD="align: center"]L1[/TD]

[TD="bgcolor: #cacaca, align: center"]2[/TD]
[TD="align: center"]A2[/TD]
[TD="align: center"]B2[/TD]
[TD="align: center"]C2[/TD]
[TD="align: center"]D2[/TD]
[TD="align: center"]E2[/TD]
[TD="align: center"]F2[/TD]
[TD="align: center"]G2[/TD]
[TD="align: center"]H2[/TD]
[TD="align: center"]I2[/TD]
[TD="align: center"]J2[/TD]
[TD="align: center"]K2[/TD]
[TD="align: center"]L2[/TD]

[TD="bgcolor: #cacaca, align: center"]3[/TD]
[TD="align: center"]A3[/TD]
[TD="align: center"]B3[/TD]
[TD="align: center"]C3[/TD]
[TD="align: center"]D3[/TD]
[TD="align: center"]E3[/TD]
[TD="align: center"]F3[/TD]
[TD="align: center"]G3[/TD]
[TD="align: center"]H3[/TD]
[TD="align: center"]I3[/TD]
[TD="align: center"]J3[/TD]
[TD="align: center"]K3[/TD]
[TD="align: center"]L3[/TD]

[TD="bgcolor: #cacaca, align: center"]4[/TD]
[TD="align: center"]A4[/TD]
[TD="align: center"]B4[/TD]
[TD="align: center"]C4[/TD]
[TD="align: center"]D4[/TD]
[TD="align: center"]E4[/TD]
[TD="align: center"]F4[/TD]
[TD="align: center"]G4[/TD]
[TD="align: center"]H4[/TD]
[TD="align: center"]I4[/TD]
[TD="align: center"]J4[/TD]
[TD="align: center"]K4[/TD]
[TD="align: center"]L4[/TD]

[TD="bgcolor: #cacaca, align: center"]5[/TD]
[TD="align: center"]A5[/TD]
[TD="align: center"]B5[/TD]
[TD="align: center"]C5[/TD]
[TD="align: center"]D5[/TD]
[TD="align: center"]E5[/TD]
[TD="align: center"]F5[/TD]
[TD="align: center"]G5[/TD]
[TD="align: center"]H5[/TD]
[TD="align: center"]I5[/TD]
[TD="align: center"]J5[/TD]
[TD="align: center"]K5[/TD]
[TD="align: center"]L5[/TD]

[TD="bgcolor: #cacaca, align: center"]6[/TD]
[TD="align: center"]A6[/TD]
[TD="align: center"]B6[/TD]
[TD="align: center"]C6[/TD]
[TD="align: center"]D6[/TD]
[TD="align: center"]E6[/TD]
[TD="align: center"]F6[/TD]
[TD="align: center"]G6[/TD]
[TD="align: center"]H6[/TD]
[TD="align: center"]I6[/TD]
[TD="align: center"]J6[/TD]
[TD="align: center"]K6[/TD]
[TD="align: center"]L6[/TD]

[TD="bgcolor: #cacaca, align: center"]7[/TD]
[TD="align: center"]A7[/TD]
[TD="align: center"]B7[/TD]
[TD="align: center"]C7[/TD]
[TD="align: center"]D7[/TD]
[TD="align: center"]E7[/TD]
[TD="align: center"]F7[/TD]
[TD="align: center"]G7[/TD]
[TD="align: center"]H7[/TD]
[TD="align: center"]I7[/TD]
[TD="align: center"]J7[/TD]
[TD="align: center"]K7[/TD]
[TD="align: center"]L7[/TD]

[TD="bgcolor: #cacaca, align: center"]8[/TD]
[TD="align: center"]A8[/TD]
[TD="align: center"]B8[/TD]
[TD="align: center"]C8[/TD]
[TD="align: center"]D8[/TD]
[TD="align: center"]E8[/TD]
[TD="align: center"]F8[/TD]
[TD="align: center"]G8[/TD]
[TD="align: center"]H8[/TD]
[TD="align: center"]I8[/TD]
[TD="align: center"]J8[/TD]
[TD="align: center"]K8[/TD]
[TD="align: center"]L8[/TD]

[TD="bgcolor: #cacaca, align: center"]9[/TD]
[TD="align: center"]A9[/TD]
[TD="align: center"]B9[/TD]
[TD="align: center"]C9[/TD]
[TD="align: center"]D9[/TD]
[TD="align: center"]E9[/TD]
[TD="align: center"]F9[/TD]
[TD="align: center"]G9[/TD]
[TD="align: center"]H9[/TD]
[TD="align: center"]I9[/TD]
[TD="align: center"]J9[/TD]
[TD="align: center"]K9[/TD]
[TD="align: center"]L9[/TD]

[TD="bgcolor: #cacaca, align: center"]10[/TD]
[TD="align: center"]A10[/TD]
[TD="align: center"]B10[/TD]
[TD="align: center"]C10[/TD]
[TD="align: center"]D10[/TD]
[TD="align: center"]E10[/TD]
[TD="align: center"]F10[/TD]
[TD="align: center"]G10[/TD]
[TD="align: center"]H10[/TD]
[TD="align: center"]I10[/TD]
[TD="align: center"]J10[/TD]
[TD="align: center"]K10[/TD]
[TD="align: center"]L10[/TD]

[TD="bgcolor: #cacaca, align: center"]11[/TD]
[TD="align: center"]A11[/TD]
[TD="align: center"]B11[/TD]
[TD="align: center"]C11[/TD]
[TD="align: center"]D11[/TD]
[TD="align: center"]E11[/TD]
[TD="align: center"]F11[/TD]
[TD="align: center"]G11[/TD]
[TD="align: center"]H11[/TD]
[TD="align: center"]I11[/TD]
[TD="align: center"]J11[/TD]
[TD="align: center"]K11[/TD]
[TD="align: center"]L11[/TD]

[TD="bgcolor: #cacaca, align: center"]12[/TD]
[TD="align: center"]A12[/TD]
[TD="align: center"]B12[/TD]
[TD="align: center"]C12[/TD]
[TD="align: center"]D12[/TD]
[TD="align: center"]E12[/TD]
[TD="align: center"]F12[/TD]
[TD="align: center"]G12[/TD]
[TD="align: center"]H12[/TD]
[TD="align: center"]I12[/TD]
[TD="align: center"]J12[/TD]
[TD="align: center"]K12[/TD]
[TD="align: center"]L12[/TD]

[TD="bgcolor: #cacaca, align: center"]13[/TD]
[TD="align: center"]A13[/TD]
[TD="align: center"]B13[/TD]
[TD="align: center"]C13[/TD]
[TD="align: center"]D13[/TD]
[TD="align: center"]E13[/TD]
[TD="align: center"]F13[/TD]
[TD="align: center"]G13[/TD]
[TD="align: center"]H13[/TD]
[TD="align: center"]I13[/TD]
[TD="align: center"]J13[/TD]
[TD="align: center"]K13[/TD]
[TD="align: center"]L13[/TD]

[TD="bgcolor: #cacaca, align: center"]14[/TD]
[TD="align: center"]A14[/TD]
[TD="align: center"]B14[/TD]
[TD="align: center"]C14[/TD]
[TD="align: center"]D14[/TD]
[TD="align: center"]E14[/TD]
[TD="align: center"]F14[/TD]
[TD="align: center"]G14[/TD]
[TD="align: center"]H14[/TD]
[TD="align: center"]I14[/TD]
[TD="align: center"]J14[/TD]
[TD="align: center"]K14[/TD]
[TD="align: center"]L14[/TD]

[TD="bgcolor: #cacaca, align: center"]15[/TD]
[TD="align: center"]A15[/TD]
[TD="align: center"]B15[/TD]
[TD="align: center"]C15[/TD]
[TD="align: center"]D15[/TD]
[TD="align: center"]E15[/TD]
[TD="align: center"]F15[/TD]
[TD="align: center"]G15[/TD]
[TD="align: center"]H15[/TD]
[TD="align: center"]I15[/TD]
[TD="align: center"]J15[/TD]
[TD="align: center"]K15[/TD]
[TD="align: center"]L15[/TD]

[TD="bgcolor: #cacaca, align: center"]16[/TD]
[TD="align: center"]A16[/TD]
[TD="align: center"]B16[/TD]
[TD="align: center"]C16[/TD]
[TD="align: center"]D16[/TD]
[TD="align: center"]E16[/TD]
[TD="align: center"]F16[/TD]
[TD="align: center"]G16[/TD]
[TD="align: center"]H16[/TD]
[TD="align: center"]I16[/TD]
[TD="align: center"]J16[/TD]
[TD="align: center"]K16[/TD]
[TD="align: center"]L16[/TD]

[TD="bgcolor: #cacaca, align: center"]17[/TD]
[TD="align: center"]A17[/TD]
[TD="align: center"]B17[/TD]
[TD="align: center"]C17[/TD]
[TD="align: center"]D17[/TD]
[TD="align: center"]E17[/TD]
[TD="align: center"]F17[/TD]
[TD="align: center"]G17[/TD]
[TD="align: center"]H17[/TD]
[TD="align: center"]I17[/TD]
[TD="align: center"]J17[/TD]
[TD="align: center"]K17[/TD]
[TD="align: center"]L17[/TD]

[TD="bgcolor: #cacaca, align: center"]18[/TD]
[TD="align: center"]A18[/TD]
[TD="align: center"]B18[/TD]
[TD="align: center"]C18[/TD]
[TD="align: center"]D18[/TD]
[TD="align: center"]E18[/TD]
[TD="align: center"]F18[/TD]
[TD="align: center"]G18[/TD]
[TD="align: center"]H18[/TD]
[TD="align: center"]I18[/TD]
[TD="align: center"]J18[/TD]
[TD="align: center"]K18[/TD]
[TD="align: center"]L18[/TD]

[TD="bgcolor: #cacaca, align: center"]19[/TD]
[TD="align: center"]A19[/TD]
[TD="align: center"]B19[/TD]
[TD="align: center"]C19[/TD]
[TD="align: center"]D19[/TD]
[TD="align: center"]E19[/TD]
[TD="align: center"]F19[/TD]
[TD="align: center"]G19[/TD]
[TD="align: center"]H19[/TD]
[TD="align: center"]I19[/TD]
[TD="align: center"]J19[/TD]
[TD="align: center"]K19[/TD]
[TD="align: center"]L19[/TD]

[TD="bgcolor: #cacaca, align: center"]20[/TD]
[TD="align: center"]A20[/TD]
[TD="align: center"]B20[/TD]
[TD="align: center"]C20[/TD]
[TD="align: center"]D20[/TD]
[TD="align: center"]E20[/TD]
[TD="align: center"]F20[/TD]
[TD="align: center"]G20[/TD]
[TD="align: center"]H20[/TD]
[TD="align: center"]I20[/TD]
[TD="align: center"]J20[/TD]
[TD="align: center"]K20[/TD]
[TD="align: center"]L20[/TD]

[TD="bgcolor: #cacaca, align: center"]21[/TD]
[TD="align: center"]A21[/TD]
[TD="align: center"]B21[/TD]
[TD="align: center"]C21[/TD]
[TD="align: center"]D21[/TD]
[TD="align: center"]E21[/TD]
[TD="align: center"]F21[/TD]
[TD="align: center"]G21[/TD]
[TD="align: center"]H21[/TD]
[TD="align: center"]I21[/TD]
[TD="align: center"]J21[/TD]
[TD="align: center"]K21[/TD]
[TD="align: center"]L21[/TD]

[TD="bgcolor: #cacaca, align: center"]22[/TD]
[TD="align: center"]A22[/TD]
[TD="align: center"]B22[/TD]
[TD="align: center"]C22[/TD]
[TD="align: center"]D22[/TD]
[TD="align: center"]E22[/TD]
[TD="align: center"]F22[/TD]
[TD="align: center"]G22[/TD]
[TD="align: center"]H22[/TD]
[TD="align: center"]I22[/TD]
[TD="align: center"]J22[/TD]
[TD="align: center"]K22[/TD]
[TD="align: center"]L22[/TD]

[TD="bgcolor: #cacaca, align: center"]23[/TD]
[TD="align: center"]A23[/TD]
[TD="align: center"]B23[/TD]
[TD="align: center"]C23[/TD]
[TD="align: center"]D23[/TD]
[TD="align: center"]E23[/TD]
[TD="align: center"]F23[/TD]
[TD="align: center"]G23[/TD]
[TD="align: center"]H23[/TD]
[TD="align: center"]I23[/TD]
[TD="align: center"]J23[/TD]
[TD="align: center"]K23[/TD]
[TD="align: center"]L23[/TD]

[TD="bgcolor: #cacaca, align: center"]24[/TD]
[TD="align: center"]A24[/TD]
[TD="align: center"]B24[/TD]
[TD="align: center"]C24[/TD]
[TD="align: center"]D24[/TD]
[TD="align: center"]E24[/TD]
[TD="align: center"]F24[/TD]
[TD="align: center"]G24[/TD]
[TD="align: center"]H24[/TD]
[TD="align: center"]I24[/TD]
[TD="align: center"]J24[/TD]
[TD="align: center"]K24[/TD]
[TD="align: center"]L24[/TD]

[TD="bgcolor: #cacaca, align: center"]25[/TD]
[TD="align: center"]A25[/TD]
[TD="align: center"]B25[/TD]
[TD="align: center"]C25[/TD]
[TD="align: center"]D25[/TD]
[TD="align: center"]E25[/TD]
[TD="align: center"]F25[/TD]
[TD="align: center"]G25[/TD]
[TD="align: center"]H25[/TD]
[TD="align: center"]I25[/TD]
[TD="align: center"]J25[/TD]
[TD="align: center"]K25[/TD]
[TD="align: center"]L25[/TD]

[TD="bgcolor: #cacaca, align: center"]26[/TD]
[TD="align: center"]A26[/TD]
[TD="align: center"]B26[/TD]
[TD="align: center"]C26[/TD]
[TD="align: center"]D26[/TD]
[TD="align: center"]E26[/TD]
[TD="align: center"]F26[/TD]
[TD="align: center"]G26[/TD]
[TD="align: center"]H26[/TD]
[TD="align: center"]I26[/TD]
[TD="align: center"]J26[/TD]
[TD="align: center"]K26[/TD]
[TD="align: center"]L26[/TD]

[TD="bgcolor: #cacaca, align: center"]27[/TD]
[TD="align: center"]A27[/TD]
[TD="align: center"]B27[/TD]
[TD="align: center"]C27[/TD]
[TD="align: center"]D27[/TD]
[TD="align: center"]E27[/TD]
[TD="align: center"]F27[/TD]
[TD="align: center"]G27[/TD]
[TD="align: center"]H27[/TD]
[TD="align: center"]I27[/TD]
[TD="align: center"]J27[/TD]
[TD="align: center"]K27[/TD]
[TD="align: center"]L27[/TD]

[TD="bgcolor: #cacaca, align: center"]28[/TD]
[TD="align: center"]A28[/TD]
[TD="align: center"]B28[/TD]
[TD="align: center"]C28[/TD]
[TD="align: center"]D28[/TD]
[TD="align: center"]E28[/TD]
[TD="align: center"]F28[/TD]
[TD="align: center"]G28[/TD]
[TD="align: center"]H28[/TD]
[TD="align: center"]I28[/TD]
[TD="align: center"]J28[/TD]
[TD="align: center"]K28[/TD]
[TD="align: center"]L28[/TD]

[TD="bgcolor: #cacaca, align: center"]29[/TD]
[TD="align: center"]A29[/TD]
[TD="align: center"]B29[/TD]
[TD="align: center"]C29[/TD]
[TD="align: center"]D29[/TD]
[TD="align: center"]E29[/TD]
[TD="align: center"]F29[/TD]
[TD="align: center"]G29[/TD]
[TD="align: center"]H29[/TD]
[TD="align: center"]I29[/TD]
[TD="align: center"]J29[/TD]
[TD="align: center"]K29[/TD]
[TD="align: center"]L29[/TD]

[TD="bgcolor: #cacaca, align: center"]30[/TD]
[TD="align: center"]A30[/TD]
[TD="align: center"]B30[/TD]
[TD="align: center"]C30[/TD]
[TD="align: center"]D30[/TD]
[TD="align: center"]E30[/TD]
[TD="align: center"]F30[/TD]
[TD="align: center"]G30[/TD]
[TD="align: center"]H30[/TD]
[TD="align: center"]I30[/TD]
[TD="align: center"]J30[/TD]
[TD="align: center"]K30[/TD]
[TD="align: center"]L30[/TD]

[TD="bgcolor: #cacaca, align: center"]31[/TD]
[TD="align: center"]65[/TD]
[TD="align: center"]66[/TD]
[TD="align: center"]67[/TD]
[TD="align: center"]68[/TD]
[TD="align: center"]69[/TD]
[TD="align: center"]70[/TD]
[TD="align: center"]71[/TD]
[TD="align: center"]72[/TD]
[TD="align: center"]73[/TD]
[TD="align: center"]74[/TD]
[TD="align: center"]75[/TD]
[TD="align: center"]76[/TD]

</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

and it returned this range repeated nine times, which seems incorrect:

BOM

*	A	B	C	D	E
Assemblies	Piece Part	Revision	Quantity	Description
D6	*	*	D4	D5
*	B7	C7	D7	A7
*	B8	C8	D8	A8
*	B9	C9	D9	A9
*	B10	C10	D10	A10
*	B11	C11	D11	A11
*	B12	C12	D12	A12
*	B13	C13	D13	A13
*	B14	C14	D14	A14
*	B15	C15	D15	A15
*	B16	C16	D16	A16
*	B17	C17	D17	A17
*	B18	C18	D18	A18
*	B19	C19	D19	A19
*	B20	C20	D20	A20
*	B21	C21	D21	A21
*	B22	C22	D22	A22
*	B23	C23	D23	A23
*	B24	C24	D24	A24
*	B25	C25	D25	A25
*	B26	C26	D26	A26
*	B27	C27	D27	A27
*	B28	C28	D28	A28
*	B29	C29	D29	A29
*	B30	C30	D30	A30
*

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:81px;"><col style="width:73px;"><col style="width:64px;"><col style="width:64px;"><col style="width:82px;"></colgroup><tbody>
[TD="bgcolor: #cacaca, align: center"]1[/TD]

[TD="bgcolor: #cacaca, align: center"]2[/TD]

[TD="bgcolor: #cacaca, align: center"]3[/TD]

[TD="bgcolor: #cacaca, align: center"]4[/TD]

[TD="bgcolor: #cacaca, align: center"]5[/TD]

[TD="bgcolor: #cacaca, align: center"]6[/TD]

[TD="bgcolor: #cacaca, align: center"]7[/TD]

[TD="bgcolor: #cacaca, align: center"]8[/TD]

[TD="bgcolor: #cacaca, align: center"]9[/TD]

[TD="bgcolor: #cacaca, align: center"]10[/TD]

[TD="bgcolor: #cacaca, align: center"]11[/TD]

[TD="bgcolor: #cacaca, align: center"]12[/TD]

[TD="bgcolor: #cacaca, align: center"]13[/TD]

[TD="bgcolor: #cacaca, align: center"]14[/TD]

[TD="bgcolor: #cacaca, align: center"]15[/TD]

[TD="bgcolor: #cacaca, align: center"]16[/TD]

[TD="bgcolor: #cacaca, align: center"]17[/TD]

[TD="bgcolor: #cacaca, align: center"]18[/TD]

[TD="bgcolor: #cacaca, align: center"]19[/TD]

[TD="bgcolor: #cacaca, align: center"]20[/TD]

[TD="bgcolor: #cacaca, align: center"]21[/TD]

[TD="bgcolor: #cacaca, align: center"]22[/TD]

[TD="bgcolor: #cacaca, align: center"]23[/TD]

[TD="bgcolor: #cacaca, align: center"]24[/TD]

[TD="bgcolor: #cacaca, align: center"]25[/TD]

[TD="bgcolor: #cacaca, align: center"]26[/TD]

[TD="bgcolor: #cacaca, align: center"]27[/TD]

[TD="align: right"]66[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]68[/TD]
[TD="align: right"]65[/TD]

</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

Making Groups in 'For Each' loop

howiechiang

New Member

Worf

Well-known Member

howiechiang

New Member

Worf

Well-known Member

Similar threads

Share this page

Making Groups in 'For Each' loop

howiechiang

New Member

Worf

Well-known Member

howiechiang

New Member

Worf

Well-known Member

Similar threads

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock