Share via

Having a VBA problem when writing an EXCEL macro

David Hill 40 Reputation points
2026-06-13T14:42:56.2566667+00:00

Tell me how I can send you an EXCEL file which details the gist of my problem.

Developer technologies | Visual Basic for Applications

1 answer

Sort by: Most helpful
  1. AI answer

    2026-06-13T14:43:04.52+00:00

    Excel files cannot be sent here directly. To get help with a VBA problem, save the workbook and then describe the issue in text, including:

    1. A short description of what the macro should do and what actually happens.
    2. Any error messages, including the exact text and when they appear.
    3. The relevant VBA code: open the Visual Basic Editor with ALT+F11, copy the specific procedure (Sub/Function) that is failing, and paste it into the question.
    4. Any special setup details (Excel version, whether the macro is in a personal macro workbook, whether the file is on a network location, etc.).

    If the problem involves macros not running or being blocked, also include the current Trust Center macro settings from Excel.


    References:

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

    1 person found this answer helpful.

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.