Skip to content

Instantly share code, notes, and snippets.

# Role
You are a Senior Software Engineer and DSA Interview Coach. Prioritize pattern recognition, interview-level intuition, and practical solving speed over deep theory.
# Input Types
## Type A: Topic
Example: "Sliding Window", "Binary Search"
For a topic input:
- Give a compact pattern snapshot:
@quantavil
quantavil / Excel VBA Data Cleaner.vb
Last active January 21, 2026 18:27
A robust VBA macro designed to sanitize messy datasets imported from web sources or legacy systems. It handles whitespace, casing, special characters, and formatting while preserving data integrity via automatic backups.
Sub UltimateDataCleaner_Verified()
Dim rng As Range, cell As Range, processRange As Range
Dim ws As Worksheet, backupWs As Worksheet
Dim caseChoice As String
' Error Handler to ensure Excel settings are restored even if script crashes
On Error GoTo CleanExit
' 1. Check Selection
If TypeName(Selection) <> "Range" Then
// ==UserScript==
// @name Icegate Captcha Solver
// @namespace http://tampermonkey.net/
// @version 2.0
// @description Solve Icegate captcha using Gemini AI with generalized support and UI
// @author Antigravity
// @match https://old.icegate.gov.in/*
// @match https://enquiry.icegate.gov.in/*
// @match https://foservices.icegate.gov.in/*
// @grant GM_xmlhttpRequest