Knowledge Base

Block adblock detection popups

uBlock Origin

  1. Right click the extension icon and then Options. A new tab will open.

  2. You’ll see a few sub-tabs, click on “Filter lists”

  3. Under “Ads”, tick the box that says “Adblock Warning Removal List”

  4. If a warning icon appears beside it, click “Update now” on the top

AdBlock Plus

Options > Advanced > Filter Lists > Adblock Warning Removal List > Active

  • AdGuard

Ad Blocker > Scroll down to add filter > AdBlock Warning Removal List is down under annoyances

  • uBlock

Enable “Adblock Warning Removal List‎” under “3rd party lists”

Block adblock detection popups was last modified: October 13th, 2019 by tabcom

Excel VBA example

 'Select cells and copy
 Range("I2:L14").Select
 Selection.Copy
 
 'Create new sheet and rename
 Sheets.Add After:=ActiveSheet
 ActiveSheet.Name = Format(Now(), "dd-MM-yy hh-mm-ss")
 
 'Paste
 Selection.PasteSpecial Paste:=xlPasteAll
 Selection.PasteSpecial Paste:=xlPasteColumnWidths, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
 Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
 
 'Cleanup
 Sheets(1).Select
 
 Range("E1").ClearContents
 Range("B4:B5").ClearContents

 Range("A1").Select
Excel VBA example was last modified: July 25th, 2018 by tabcom

Move files into folders

I have a set of files:

.\Cat.txt

.\Dog.txt

I want to end up with this:

.\Cat\Cat.txt

.\Dog\Dog.txt

Solution:

for %i in (*) do md "%~ni"

for %i in (*) do move "%i" "%~ni"
Move files into folders was last modified: May 15th, 2018 by tabcom