Agent skill · Audited from source
Excel Vba Search Copy And Format Macro
skill · ECNU-ICALK/AutoSkillLicence not declaredAudited 14 Oct 2026 · source 04e912cff54b
Is it safe? Yes — SAFE, grade B (89/100). We read this skill's source at commit 04e912cff54b and found no filesystem, network or shell access and no hard-coded secrets. What it does: A VBA subroutine to search a source sheet for a value, copy all matches to a destination sheet, apply random column colors (excluding white), highlight source cells yellow, and log the search term.
Cite
Cite this page
ModelsAtlas. “Excel Vba Search Copy And Format Macro (ECNU-ICALK/AutoSkill)”. Retrieved 14 Oct 2026. https://modelsatlas.com/skills/ecnu-icalk/excel-vba-search-copy-and-format-macro
Trust audit
Audit 0.4.1 · source read 14 Oct 2026
SAFE means nothing in the source contradicts what the skill says it does. Grade B is shared by 16,667 of 17,602 audited skills.
What the source does
- FilesystemNone observedNo reads or writes in the source
- NetworkNone observedNo outbound calls in the source
- ShellNone observedNo commands run in the source
- DependenciesPinnedNothing floats
- SecretsNone foundNo keys in source
Five audit layers
| Layer | What we check | Result | Findings |
|---|---|---|---|
L0 Provenance | Repo owner, licence, archive status, activity | PASS | 0 |
L1 Static source | Secrets, path traversal, supply chain, hidden code | NA | 0 |
L2 Instructions | Prompt injection, authority framing, hidden directives | PASS | 0 |
L3 Inventory | The files and declarations match the source | PASS | 0 |
L4 Sandbox | Run in isolation and watch behaviour | SKIPPED why | 0 |
Gates applied: no behavioural pass.
Findings (0)
No findings at any severity. We re-audit when the source changes.
Audit 0.4.1 · source sha 04e912cff54b · 14 Oct 2026Report an issue or request a re-scan
Provenance
Who published it, and what the verdict is pinned to
- PublisherECNU-ICALK GitHub organizationOwner of the repository this skill is read from
- Source folderECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/excel-vba-search-copy-and-format-macroThe exact folder we audited
- LicenceNot declaredAs the repository states it
- Commit pinned for this verdict04e912cff54bA new audit runs when the source changes
- Repository statusNot archivedLast push 157 days ago
- Sandboxed runNot runSkills are read, not executed; layer L4 is skipped
What it tells the agent
Full source on GitHub ↗Its description: A VBA subroutine to search a source sheet for a value, copy all matches to a destination sheet, apply random column colors (excluding white), highlight source cells yellow, and log the search term.
--- id: "ac17ef7a-378d-459f-ab00-73829c036e46" name: "Excel VBA Search Copy and Format Macro" description: "A VBA subroutine to search a source sheet for a value, copy all matches to a destination sheet, apply random column colors (excluding white), highlight source cells yellow, and log the search term." version: "0.1.0" tags: - "vba" - "excel" - "automation" - "search" - "formatting" triggers: - "create vba macro to search and copy" - "excel vba search highlight and copy" - "search system sheet copy to licente" - "vba random column color exclude white" - "search and log value in excel vba" --- # Excel VBA Search Copy and Format Macro A VBA subroutine to search a source sheet for a value, copy all matches to a destination sheet, apply random column colors (excluding white), highlight source cells yellow, and log the search term. ## Prompt # Role & Objective You are an Excel VBA expert. Write a VBA subroutine that searches a source worksheet for a user-defined value, copies all matching cells to a destination worksheet, and applies specific formatting and logging rules. # Operational Rules & Constraints 1. **Input**: Prompt the user for a search value using an InputBox. 2. **Search Logic**: Perform a case-insensitive, partial match search (using `InStr`) across the used range of the Source Sheet. 3. **Matching**: Identify ALL cells containing the search value. Do not stop at the first match. 4. **Copy Operation**: Copy the found cells from the Source Sheet to the Destination Sheet at the exact same cell addresses. 5. **Destination Sheet Actions**: - Change the value of the copied cells to "X". - Apply a random background color to the entire columns where data was copied. - Ensure the random color generation excludes white (RGB 16777215). - Copy the search term into cell A2 of the Destination Sheet. 6. **Source Sheet Actions**: - Highlight the cells where the data was found with a yellow background (RGB 255, 255, 0). 7. **Data Structures**: Use a Dictionary object to track unique columns for coloring to avoid errors with `Intersect` or `Collection.Exists`. # Anti-Patterns - Do not stop the search after finding the first match. - Do not use white as a random column color. - Do not use `Intersect` on ranges that might be Nothing; use a Dictionary to track columns. - Do not hardcode sheet names like "System" or "Licente" unless specified; use variables for Source and Destination sheets. ## Triggers - create vba macro to search and copy - excel vba search highlight and copy - search system sheet copy to licente - vba random column color exclude white - search and log value in excel vba
Excerpt, first 2,670 characters of SKILL.md, verbatim from the audited commit. It is text from someone else’s repository, quoted so you can judge it before your agent reads it.
Install
Pinned to the audited commit 04e912c
git clone https://github.com/ECNU-ICALK/AutoSkill git -C AutoSkill checkout 04e912cff54b
The author documents no install command, so this uses the repository directly. Our verdict covers commit 04e912cff54b only.
Works in
The author has not said which agents this skill supports, and we have not tested it in any.
Audit history
Every audit, every source change
- ✓SAFE B 89 / 100
first audit · source
04e912cff54b
Similar skills
All data & analysis skills →ECNU-ICALK/AutoSkill
Executes a 1-back test by comparing the current input to the immediately preceding input in a sequence, reporting the prior item and a match indicator.
ECNU-ICALK/AutoSkill
Identifies the critical 20% of a given topic that yields 80% of the results and creates a focused learning plan to master it.
ECNU-ICALK/AutoSkill
Act as a friendly English teacher for A1 students. Correct errors briefly, ask clarifying questions to maintain dialogue, and strictly limit responses to 100 words.
ECNU-ICALK/AutoSkill
运用理性情绪疗法ABC模型,按客观事实→情绪反应→自动想法→合理/不合理区分四步顺序,引导来访者辨析创伤相关歪曲信念,并通过挑战式提问促发认知重评。
ECNU-ICALK/AutoSkill
Generates academic content components (introductions, conclusions, titles, topics) and full expository essays. Includes specialized capabilities for refining research paper titles with specific constraints, emphasis,…
ECNU-ICALK/AutoSkill
Draft or improve emails to professors using simple vocabulary, friendly tone, and straightforward grammar.
Questions about Excel Vba Search Copy And Format Macro
What does the Excel Vba Search Copy And Format Macro skill do?
Is Excel Vba Search Copy And Format Macro safe to install?
What can Excel Vba Search Copy And Format Macro access on my machine?
How current is this page?
Sources
- github.com/ECNU-ICALK/AutoSkill/tree/main/SkillBank/ConvSkill/en — the audited source at commit 04e912cff54b and every finding aboveObserved · 14 Oct 2026
Spotted something wrong? Report a correction · Methodology
Keep going in your AI
Opens with this page as the source. We add nothing else to the prompt.
- What does the Excel Vba Search Copy And Format Macro skill do?
- Is Excel Vba Search Copy And Format Macro safe to install?
- What can Excel Vba Search Copy And Format Macro access on my machine?