vba indexed search syntax

parkerbelt

Active Member
Joined
May 23, 2014
Messages
377
I have an Excel workbook that has a sheet that has a list of 500 stores numbered Store number 1, store number 7 store number 11, etc.. - these are my test stores. The store number is in column A. I'm calling this sheet "500 Test Stores". The sheet doesn't contain duplicate store numbers, it is an index if you will.

I have another Excel workbook that has a large list of store data, which includes store number in column A along with Sales data in a different column and Quantity on-hand in another column, and other data in other columns, etc.. I'm calling this sheet "Test Dump". This sheet contains multiple store numbers that are the same, because the data goes with different items that are sold at the same store.

I'm trying to write a program that will look at each cell in column A of the 500 Test Stores sheet and look for a match in the Test Dump sheet and if it finds a match, copy the row of data where the match is and paste it into a different tab that I call "Test Stores Data".
If the store number doesn't match, I want to copy the row of data into a tab called "All Other Stores Data".

I'm a bit inexperienced and rusty - and each time I try to create my loops, I keep duplicating data and the program is really in-efficient.
Does anyone know how to write the code so that my loop is efficient, it sorts the data like I want it to and it doesn't duplicate any data?

Here's what I've attempted, but it is going to duplicate data if allowed to run through:

HTML:
Dim SearchStore As LongDim lastrow500 As LongDim lastrow As Long           Sheets("500 Test Stores").Select    lastrow500 = Cells(Rows.Count, "A").End(xlUp).Row        Sheets("Temp Dump").Select    lastrow = Cells(Rows.Count, "A").End(xlUp).Row    Dim i As Long        i = 2
Dim its As Long        its = 2
Dim iao As Long
    iao = 2
Dim itsl As Long        itsl = 2

' Start of loop for Test Stores

Do Until itsl = lastrow500 + 1
    Sheets("500 Test Stores").Select
    SearchStore = Range("A" & its).Value.Select        
    Do Until i = lastrow + 1
                Sheets("Temp Dump").Select            Range("A" & i).Select

        If Range("A" & i).Value = SearchStore Then            Rows(ActiveCell.Row).Select            Selection.Copy            Sheets("Test Stores Data").Select            Range("A" & i).Select            ActiveSheet.Paste            i = i + 1            its = its + 1                    Else            Rows(ActiveCell.Row).Select            Selection.Copy            Sheets("All Other Stores Data").Select            Range("A" & iao).Select            ActiveSheet.Paste            iao = iao + 1            i = i + 1                    End If            Loop
    itsl = itsl + 1    Loop
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
Try this


Code:
Sub search_numbers()
    Dim sh1 As Worksheet, sh2 As Worksheet, sh3 As Worksheet, sh4 As Worksheet
    
[COLOR=#0000ff]    Set sh1 = Sheets("500 Test Stores")[/COLOR]
[COLOR=#008000]    Set sh2 = Sheets("Test Dump")[/COLOR]
[COLOR=#800000]    Set sh3 = Sheets("Test Stores Data")[/COLOR]
[COLOR=#800080]    Set sh4 = Sheets("All Other Stores Data")[/COLOR]
    
    For Each c In sh1.Range("A2", sh1.Range("A" & Rows.Count).End(xlUp))
        Set f = sh2.Range("A:A").Find(c.Value, LookIn:=xlValues, lookat:=xlWhole)
        If Not f Is Nothing Then
[COLOR=#008000]            sh2.Rows(f.Row).Copy [/COLOR][COLOR=#800000]sh3.Range("A" & sh3.Rows.Count).End(xlUp)(2)[/COLOR][COLOR=#008000][/COLOR]
        Else
[COLOR=#0000ff]            sh1.Rows(c.Row).Copy [/COLOR][COLOR=#800080]sh4.Range("A" & sh4.Rows.Count).End(xlUp)(2)[/COLOR][COLOR=#0000ff][/COLOR]
        End If
    Next
    MsgBox "Done"
End Sub
 
Upvote 0
I'm getting Run-Time error '9':
Subscript out of range and this line is where it stopped:
Set sh2 = Sheets("Test Dump")


Not sure why
Try this


Code:
Sub search_numbers()
    Dim sh1 As Worksheet, sh2 As Worksheet, sh3 As Worksheet, sh4 As Worksheet
    
[COLOR=#0000ff]    Set sh1 = Sheets("500 Test Stores")[/COLOR]
[COLOR=#008000]    Set sh2 = Sheets("Test Dump")[/COLOR]
[COLOR=#800000]    Set sh3 = Sheets("Test Stores Data")[/COLOR]
[COLOR=#800080]    Set sh4 = Sheets("All Other Stores Data")[/COLOR]
    
    For Each c In sh1.Range("A2", sh1.Range("A" & Rows.Count).End(xlUp))
        Set f = sh2.Range("A:A").Find(c.Value, LookIn:=xlValues, lookat:=xlWhole)
        If Not f Is Nothing Then
[COLOR=#008000]            sh2.Rows(f.Row).Copy [/COLOR][COLOR=#800000]sh3.Range("A" & sh3.Rows.Count).End(xlUp)(2)[/COLOR]
        Else
[COLOR=#0000ff]            sh1.Rows(c.Row).Copy [/COLOR][COLOR=#800080]sh4.Range("A" & sh4.Rows.Count).End(xlUp)(2)[/COLOR]
        End If
    Next
    MsgBox "Done"
End Sub
 
Upvote 0
Your code worked to find a match and to put one line of data from the match into the Test Stores Data tab, but it didn't put the other rows of data from the other item numbers in there.

It also didn't put any non-matches data into the All Other Stores Data tab.

Thanks though!

Try this


Code:
Sub search_numbers()
    Dim sh1 As Worksheet, sh2 As Worksheet, sh3 As Worksheet, sh4 As Worksheet
    
[COLOR=#0000ff]    Set sh1 = Sheets("500 Test Stores")[/COLOR]
[COLOR=#008000]    Set sh2 = Sheets("Test Dump")[/COLOR]
[COLOR=#800000]    Set sh3 = Sheets("Test Stores Data")[/COLOR]
[COLOR=#800080]    Set sh4 = Sheets("All Other Stores Data")[/COLOR]
    
    For Each c In sh1.Range("A2", sh1.Range("A" & Rows.Count).End(xlUp))
        Set f = sh2.Range("A:A").Find(c.Value, LookIn:=xlValues, lookat:=xlWhole)
        If Not f Is Nothing Then
[COLOR=#008000]            sh2.Rows(f.Row).Copy [/COLOR][COLOR=#800000]sh3.Range("A" & sh3.Rows.Count).End(xlUp)(2)[/COLOR]
        Else
[COLOR=#0000ff]            sh1.Rows(c.Row).Copy [/COLOR][COLOR=#800080]sh4.Range("A" & sh4.Rows.Count).End(xlUp)(2)[/COLOR]
        End If
    Next
    MsgBox "Done"
End Sub
 
Upvote 0
Your code worked to find a match and to put one line of data from the match into the Test Stores Data tab, but it didn't put the other rows of data from the other item numbers in there.

It also didn't put any non-matches data into the All Other Stores Data tab.

Thanks though!


You can paste a sample of your data from the sheets

("500 Test Stores")
("Temp Dump")
 
Upvote 0
You can paste a sample of your data from the sheets

("500 Test Stores")
("Temp Dump")

Below is the information that you requested. If the store number is in the 500 Test Stores list, I want to copy all of the rows for that store from the Temp Dump tab and put the data in the Test Stores Data tab. If the store number is not in the 500 Test Stores list, I want to copy all of the rows for that store from the Temp Dump tab and put the data in the All Other Stores Data tab.

500 Test Stores Sample:

Store NbrStore NameCityState
1ROGERS, ARROGERSAR
11MOUNTAIN HOME ARMOUNTAIN HOMEAR
15WEST PLAINS MOWEST PLAINSMO
19POPLAR BLUFF MOPOPLAR BLUFFMO
22PRYOR OKPRYOROK
35MANHATTAN KSMANHATTANKS
41BARTLESVILLE OKBARTLESVILLEOK
45JONESBORO ARJONESBOROAR
46BOLIVAR MOBOLIVARMO
58RUSSELLVILLE ARRUSSELLVILLEAR




<colgroup><col><col><col><col></colgroup><tbody>
</tbody>



Temp Dump Sample:

Store NbrCityStateZip CodePrime Item NbrPrime Item DescUPCVendor NameAcct Dept NbrDept Category DescriptionDept Subcategory DescriptionMDSE Category INTLFineline NumberFineline DescriptionBuilding AddressData Type201908201909201910201911201912201913201914201916
1ROGERSAR727561149131RIDX 19.6OZ POWDER0001920080307RB USA HOLDINGS LLC11PLUMBINGCHEMICALSPOWER TOOLS103Septic Chemicals2110 W WALNUT STPOS Sales19.9439.8829.9119.9439.889.9739.880
1ROGERSAR727561149131RIDX 19.6OZ POWDER0001920080307RB USA HOLDINGS LLC11PLUMBINGCHEMICALSPOWER TOOLS103Septic Chemicals2110 W WALNUT STPOS Qty24324140
1ROGERSAR727561149131RIDX 19.6OZ POWDER0001920080307RB USA HOLDINGS LLC11PLUMBINGCHEMICALSPOWER TOOLS103Septic Chemicals2110 W WALNUT STCurr Str On Hand Qty00000009
1ROGERSAR727561149131RIDX 19.6OZ POWDER0001920080307RB USA HOLDINGS LLC11PLUMBINGCHEMICALSPOWER TOOLS103Septic Chemicals2110 W WALNUT STCurr Str On Order Qty00000000
1ROGERSAR727561149131RIDX 19.6OZ POWDER0001920080307RB USA HOLDINGS LLC11PLUMBINGCHEMICALSPOWER TOOLS103Septic Chemicals2110 W WALNUT STCurr Str In Transit Qty00000000
1ROGERSAR727561149131RIDX 19.6OZ POWDER0001920080307RB USA HOLDINGS LLC11PLUMBINGCHEMICALSPOWER TOOLS103Septic Chemicals2110 W WALNUT STCurr Str In Whse Qty00000000
1ROGERSAR727561149131RIDX 19.6OZ POWDER0001920080307RB USA HOLDINGS LLC11PLUMBINGCHEMICALSPOWER TOOLS103Septic Chemicals2110 W WALNUT STAvg Repl Instock %1001001001001001001000
1ROGERSAR727561149131RIDX 19.6OZ POWDER0001920080307RB USA HOLDINGS LLC11PLUMBINGCHEMICALSPOWER TOOLS103Septic Chemicals2110 W WALNUT STCurr Repl Instock %1000000000
1ROGERSAR72756567066733MS SN SP SAVER W LNR0088952621579IMPORT-TESTRITE INTERNATIONAL11BATH DECORBATH FURNITUREBATH DECOR6008OPP Space Savers2110 W WALNUT STPOS Sales39.6819.8419.84059.52039.680
1ROGERSAR72756567066733MS SN SP SAVER W LNR0088952621579IMPORT-TESTRITE INTERNATIONAL11BATH DECORBATH FURNITUREBATH DECOR6008OPP Space Savers2110 W WALNUT STPOS Qty21103020
1ROGERSAR72756567066733MS SN SP SAVER W LNR0088952621579IMPORT-TESTRITE INTERNATIONAL11BATH DECORBATH FURNITUREBATH DECOR6008OPP Space Savers2110 W WALNUT STCurr Str On Hand Qty00000007
1ROGERSAR72756567066733MS SN SP SAVER W LNR0088952621579IMPORT-TESTRITE INTERNATIONAL11BATH DECORBATH FURNITUREBATH DECOR6008OPP Space Savers2110 W WALNUT STCurr Str On Order Qty00000000
1ROGERSAR72756567066733MS SN SP SAVER W LNR0088952621579IMPORT-TESTRITE INTERNATIONAL11BATH DECORBATH FURNITUREBATH DECOR6008OPP Space Savers2110 W WALNUT STCurr Str In Transit Qty00000000
1ROGERSAR72756567066733MS SN SP SAVER W LNR0088952621579IMPORT-TESTRITE INTERNATIONAL11BATH DECORBATH FURNITUREBATH DECOR6008OPP Space Savers2110 W WALNUT STCurr Str In Whse Qty00000000
1ROGERSAR72756567066733MS SN SP SAVER W LNR0088952621579IMPORT-TESTRITE INTERNATIONAL11BATH DECORBATH FURNITUREBATH DECOR6008OPP Space Savers2110 W WALNUT STAvg Repl Instock %1001001001001001001000
1ROGERSAR72756567066733MS SN SP SAVER W LNR0088952621579IMPORT-TESTRITE INTERNATIONAL11BATH DECORBATH FURNITUREBATH DECOR6008OPP Space Savers2110 W WALNUT STCurr Repl Instock %1000000000
1ROGERSAR72756571189411MS RND WHT WOOD0694294590008IMPORT-NINGBO BOFAN SANITARY W11TOILET SEATSROUNDTOILET SEATS6230ROUND WOOD SEATS2110 W WALNUT STPOS Sales022.8822.8828.617.1617.1628.60
1ROGERSAR72756571189411MS RND WHT WOOD0694294590008IMPORT-NINGBO BOFAN SANITARY W11TOILET SEATSROUNDTOILET SEATS6230ROUND WOOD SEATS2110 W WALNUT STPOS Qty04453350
1ROGERSAR72756571189411MS RND WHT WOOD0694294590008IMPORT-NINGBO BOFAN SANITARY W11TOILET SEATSROUNDTOILET SEATS6230ROUND WOOD SEATS2110 W WALNUT STCurr Str On Hand Qty00000007
1ROGERSAR72756571189411MS RND WHT WOOD0694294590008IMPORT-NINGBO BOFAN SANITARY W11TOILET SEATSROUNDTOILET SEATS6230ROUND WOOD SEATS2110 W WALNUT STCurr Str On Order Qty00000000
1ROGERSAR72756571189411MS RND WHT WOOD0694294590008IMPORT-NINGBO BOFAN SANITARY W11TOILET SEATSROUNDTOILET SEATS6230ROUND WOOD SEATS2110 W WALNUT STCurr Str In Transit Qty00000000
1ROGERSAR72756571189411MS RND WHT WOOD0694294590008IMPORT-NINGBO BOFAN SANITARY W11TOILET SEATSROUNDTOILET SEATS6230ROUND WOOD SEATS2110 W WALNUT STCurr Str In Whse Qty00000000
1ROGERSAR72756571189411MS RND WHT WOOD0694294590008IMPORT-NINGBO BOFAN SANITARY W11TOILET SEATSROUNDTOILET SEATS6230ROUND WOOD SEATS2110 W WALNUT STAvg Repl Instock %1001001001001001001000
1ROGERSAR72756571189411MS RND WHT WOOD0694294590008IMPORT-NINGBO BOFAN SANITARY W11TOILET SEATSROUNDTOILET SEATS6230ROUND WOOD SEATS2110 W WALNUT STCurr Repl Instock %1000000000
11MOUNTAIN HOMEAR726531149131RIDX 19.6OZ POWDER0001920080307RB USA HOLDINGS LLC11PLUMBINGCHEMICALSPOWER TOOLS103Septic Chemicals65 WAL MART DRPOS Sales329.01239.28418.74319.04219.34289.13358.920
11MOUNTAIN HOMEAR726531149131RIDX 19.6OZ POWDER0001920080307RB USA HOLDINGS LLC11PLUMBINGCHEMICALSPOWER TOOLS103Septic Chemicals65 WAL MART DRPOS Qty332442322229360
11MOUNTAIN HOMEAR726531149131RIDX 19.6OZ POWDER0001920080307RB USA HOLDINGS LLC11PLUMBINGCHEMICALSPOWER TOOLS103Septic Chemicals65 WAL MART DRCurr Str On Hand Qty0000000194
11MOUNTAIN HOMEAR726531149131RIDX 19.6OZ POWDER0001920080307RB USA HOLDINGS LLC11PLUMBINGCHEMICALSPOWER TOOLS103Septic Chemicals65 WAL MART DRCurr Str On Order Qty00000000
11MOUNTAIN HOMEAR726531149131RIDX 19.6OZ POWDER0001920080307RB USA HOLDINGS LLC11PLUMBINGCHEMICALSPOWER TOOLS103Septic Chemicals65 WAL MART DRCurr Str In Transit Qty00000000
11MOUNTAIN HOMEAR726531149131RIDX 19.6OZ POWDER0001920080307RB USA HOLDINGS LLC11PLUMBINGCHEMICALSPOWER TOOLS103Septic Chemicals65 WAL MART DRCurr Str In Whse Qty00000000
11MOUNTAIN HOMEAR726531149131RIDX 19.6OZ POWDER0001920080307RB USA HOLDINGS LLC11PLUMBINGCHEMICALSPOWER TOOLS103Septic Chemicals65 WAL MART DRAvg Repl Instock %1001001001001001001000
11MOUNTAIN HOMEAR726531149131RIDX 19.6OZ POWDER0001920080307RB USA HOLDINGS LLC11PLUMBINGCHEMICALSPOWER TOOLS103Septic Chemicals65 WAL MART DRCurr Repl Instock %1000000000
11MOUNTAIN HOMEAR72653567066733MS SN SP SAVER W LNR0088952621579IMPORT-TESTRITE INTERNATIONAL11BATH DECORBATH FURNITUREBATH DECOR6008OPP Space Savers65 WAL MART DRPOS Sales19.8419.8439.68079.36000
11MOUNTAIN HOMEAR72653567066733MS SN SP SAVER W LNR0088952621579IMPORT-TESTRITE INTERNATIONAL11BATH DECORBATH FURNITUREBATH DECOR6008OPP Space Savers65 WAL MART DRPOS Qty11204000
11MOUNTAIN HOMEAR72653567066733MS SN SP SAVER W LNR0088952621579IMPORT-TESTRITE INTERNATIONAL11BATH DECORBATH FURNITUREBATH DECOR6008OPP Space Savers65 WAL MART DRCurr Str On Hand Qty00000005
11MOUNTAIN HOMEAR72653567066733MS SN SP SAVER W LNR0088952621579IMPORT-TESTRITE INTERNATIONAL11BATH DECORBATH FURNITUREBATH DECOR6008OPP Space Savers65 WAL MART DRCurr Str On Order Qty00000000
11MOUNTAIN HOMEAR72653567066733MS SN SP SAVER W LNR0088952621579IMPORT-TESTRITE INTERNATIONAL11BATH DECORBATH FURNITUREBATH DECOR6008OPP Space Savers65 WAL MART DRCurr Str In Transit Qty00000006
11MOUNTAIN HOMEAR72653567066733MS SN SP SAVER W LNR0088952621579IMPORT-TESTRITE INTERNATIONAL11BATH DECORBATH FURNITUREBATH DECOR6008OPP Space Savers65 WAL MART DRCurr Str In Whse Qty00000000
11MOUNTAIN HOMEAR72653567066733MS SN SP SAVER W LNR0088952621579IMPORT-TESTRITE INTERNATIONAL11BATH DECORBATH FURNITUREBATH DECOR6008OPP Space Savers65 WAL MART DRAvg Repl Instock %1001001001001001001000
11MOUNTAIN HOMEAR72653567066733MS SN SP SAVER W LNR0088952621579IMPORT-TESTRITE INTERNATIONAL11BATH DECORBATH FURNITUREBATH DECOR6008OPP Space Savers65 WAL MART DRCurr Repl Instock %1000000000
11MOUNTAIN HOMEAR72653571189411MS RND WHT WOOD0694294590008IMPORT-NINGBO BOFAN SANITARY W11TOILET SEATSROUNDTOILET SEATS6230ROUND WOOD SEATS65 WAL MART DRPOS Sales0011.4468.6468.6428.657.20
11MOUNTAIN HOMEAR72653571189411MS RND WHT WOOD0694294590008IMPORT-NINGBO BOFAN SANITARY W11TOILET SEATSROUNDTOILET SEATS6230ROUND WOOD SEATS65 WAL MART DRPOS Qty00212125100
11MOUNTAIN HOMEAR72653571189411MS RND WHT WOOD0694294590008IMPORT-NINGBO BOFAN SANITARY W11TOILET SEATSROUNDTOILET SEATS6230ROUND WOOD SEATS65 WAL MART DRCurr Str On Hand Qty00000003
11MOUNTAIN HOMEAR72653571189411MS RND WHT WOOD0694294590008IMPORT-NINGBO BOFAN SANITARY W11TOILET SEATSROUNDTOILET SEATS6230ROUND WOOD SEATS65 WAL MART DRCurr Str On Order Qty00000000
11MOUNTAIN HOMEAR72653571189411MS RND WHT WOOD0694294590008IMPORT-NINGBO BOFAN SANITARY W11TOILET SEATSROUNDTOILET SEATS6230ROUND WOOD SEATS65 WAL MART DRCurr Str In Transit Qty00000006
11MOUNTAIN HOMEAR72653571189411MS RND WHT WOOD0694294590008IMPORT-NINGBO BOFAN SANITARY W11TOILET SEATSROUNDTOILET SEATS6230ROUND WOOD SEATS65 WAL MART DRCurr Str In Whse Qty00000000
11MOUNTAIN HOMEAR72653571189411MS RND WHT WOOD0694294590008IMPORT-NINGBO BOFAN SANITARY W11TOILET SEATSROUNDTOILET SEATS6230ROUND WOOD SEATS65 WAL MART DRAvg Repl Instock %10001001001001001000
11MOUNTAIN HOMEAR72653571189411MS RND WHT WOOD0694294590008IMPORT-NINGBO BOFAN SANITARY W11TOILET SEATSROUNDTOILET SEATS6230ROUND WOOD SEATS65 WAL MART DRCurr Repl Instock %1000000000

<colgroup><col><col span="3"><col><col span="2"><col><col><col span="7"><col span="8"></colgroup><tbody>
</tbody>
 
Upvote 0
If the store number is in the 500 Test Stores list, I want to
copy all of the rows for that store from the Temp Dump tab and put the data in the Test Stores Data tab.

If the store number is not in the 500 Test Stores list, I want to
copy all of the rows for that store from the Temp Dump tab and put the data in the All Other Stores Data tab.

Try this please.

Code:
Sub search_numbers()
    Dim sh1 As Worksheet, sh2 As Worksheet, sh3 As Worksheet, sh4 As Worksheet
    
    Set sh1 = Sheets("500 Test Stores")
    Set sh2 = Sheets("Temp Dump")
    Set sh3 = Sheets("Test Stores Data")
    Set sh4 = Sheets("All Other Stores Data")
    
    sh3.Rows("2:" & Rows.Count).ClearContents
    sh4.Rows("2:" & Rows.Count).ClearContents
    For Each c In sh2.Range("A2", sh2.Range("A" & Rows.Count).End(xlUp))
        Set f = sh1.Range("A:A").Find(c.Value, LookIn:=xlValues, lookat:=xlWhole)
        If Not f Is Nothing Then
            sh2.Rows(f.Row).Copy sh3.Range("A" & sh3.Rows.Count).End(xlUp)(2)
        Else
            sh2.Rows(c.Row).Copy sh4.Range("A" & sh4.Rows.Count).End(xlUp)(2)
        End If
    Next
    MsgBox "Done"
End Sub
 
Upvote 0
I was running my program, the code that I had written and got hung in a loop, so I ended excel using task manager and now Excel is telling me "Because of your security settings, macros have been disabled." and when I try to go into the Trust Center, the option to enable macros is greyed out and I can't turn it back on to try your code. Do you know of a way to turn the option back on? I'm going to make a post on this forum for that. When I get this back up and running, I'll try your code and reply. Thanks!
 
Upvote 0
I was running my program, the code that I had written and got hung in a loop, so I ended excel using task manager and now Excel is telling me "Because of your security settings, macros have been disabled." and when I try to go into the Trust Center, the option to enable macros is greyed out and I can't turn it back on to try your code. Do you know of a way to turn the option back on? I'm going to make a post on this forum for that. When I get this back up and running, I'll try your code and reply. Thanks!


How many records do you have on the "temp dump" sheet?
 
Upvote 0

Forum statistics

Threads
1,213,557
Messages
6,114,291
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top