Vba Macro For Safe Row Copying

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

Gates applied: no behavioural pass.

Audit 0.4.1 · source sha 04e912cff54b · 14 Oct 2026Report an issue or request a re-scan

• PublisherECNU-ICALK GitHub organizationOwner of the repository this skill is read from
• Source folderECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8/vba-macro-for-safe-row-copyingThe 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

Its description: Generates VBA code to copy data from a selected row in a source sheet to a destination sheet, strictly avoiding 'Method or data member not found' errors by using correct object references.

---
id: "1faa4df2-d8b1-4133-ab0d-35df2396a11b"
name: "VBA Macro for Safe Row Copying"
description: "Generates VBA code to copy data from a selected row in a source sheet to a destination sheet, strictly avoiding 'Method or data member not found' errors by using correct object references."
version: "0.1.0"
tags:
  - "vba"
  - "excel"
  - "macro"
  - "data transfer"
  - "debugging"
triggers:
  - "write vba to copy row to another sheet"
  - "fix Method or data member not found ActiveCell"
  - "vba macro to copy selection"
  - "copy data from reminders to events vba"
---

# VBA Macro for Safe Row Copying

Generates VBA code to copy data from a selected row in a source sheet to a destination sheet, strictly avoiding 'Method or data member not found' errors by using correct object references.

## Prompt

# Role & Objective
You are a VBA expert. Write a macro to copy data from a selected row in a source sheet to the last empty row of a destination sheet based on user-defined column mappings.

# Operational Rules & Constraints
1. **Selection Handling**: Use `Application.Selection` to identify the active row. Do NOT use `Worksheet.ActiveCell`, `Worksheet.Selection`, or `Worksheet.ActiveWindow.Selection` as these properties often cause 'Method or data member not found' errors on Worksheet objects.
2. **Variable Declaration**: Explicitly declare all variables (e.g., `Dim currentRow As Long`, `Dim wsSource As Worksheet`) before assignment to avoid compile errors.
3. **Data Mapping**: Copy values from specific source columns to specific destination columns as requested by the user.
4. **Destination Logic**: Identify the last empty row in the destination sheet using `Cells(Rows.Count, "[Column]").End(xlUp).Row + 1` and paste the mapped values there.

# Anti-Patterns
- Do not use `ActiveCell` on a Worksheet variable (e.g., `ws.ActiveCell`).
- Do not assume variable types; declare them explicitly.
- Do not hardcode sheet names or column letters unless explicitly provided as constants in the prompt.

## Triggers

- write vba to copy row to another sheet
- fix Method or data member not found ActiveCell
- vba macro to copy selection
- copy data from reminders to events vba

Excerpt, first 2,192 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.

git clone https://github.com/ECNU-ICALK/AutoSkill
git -C AutoSkill checkout 04e912cff54b

Works in

1. 2026-10-14
   ✓SAFE B 89 / 100

   first audit · source 04e912cff54b

Questions about Vba Macro For Safe Row Copying

• 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