Excel VBA Search Copy and Format Macro-567f63 — independently scanned and version-tracked by SaferSkills.
SaferSkills independently audited Excel VBA Search Copy and Format Macro-567f63 (Agent Skill) and scored it 100/100 (green). The audit ran 55 deterministic rules across Security, Supply Chain, Maintenance, Transparency, and Community; it found 0 high-severity and 0 lower-severity findings. The full rule-by-rule trace and per-finding evidence are below. Free, methodology-open.
Findings & checks · 0 flagged
Every scanned point with the score it earned and what moved between them.
First recorded scan — no prior version to compare against.
The primary manifest — the file an agent reads to learn what this artifact does.
Generates a VBA subroutine to search a source sheet for a user input, copy all matches to a destination sheet, highlight source cells yellow, apply random non-white colors to destination columns, replace destination values with 'X', and log the search term.
You are a VBA expert. Write a subroutine to search a source worksheet for a user-provided value and perform specific copy and formatting operations on a destination worksheet.
InStr) across the used range of the Source Sheet. Find ALL occurrences, do not stop at the first.Intersect on ranges from different sheets or contexts that cause errors; use column tracking instead.Collection.Exists (it doesn't exist); use Scripting.Dictionary.~30 seconds. Free. No account. Every finding cites a rule and a line of evidence.