Having a VBA problem when writing an EXCEL macro

David Hill 40 Reputation points

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

  1. David Hill 40 Reputation points

    I need to send you an EXCEL file so you can understand the problem.

  2. David Hill 40 Reputation points

    How do I send you a simple EXCEL file to illustrate my macro problem ?

  3. Senthil kumar 685 Reputation points

    Hi @David Hill

    please explain more about your issue or send the screenshot. its better to understand your issue.

    Thanks

  4. Nancy Vo (WICLOUD CORPORATION) 5,865 Reputation points ā€¢ Microsoft External Staff ā€¢ Moderator

    Hello @David Hill ,

    Thanks for your question.

    Since you did not provide detailed information about the issue, I cannot reproduce it without more details. To investigate further, Iā€™d like to know:

    • What is the macro supposed to do?
    • What error or unexpected behavior is occurring?
    • Your Excel version.

    You can share the VBA code here along with a description of the actual problem. You can also upload a screenshot of the error or spreadsheet using the Insert Image button in the reply editor.

    Iā€™d be happy to investigate further. Thank you.

  5. Nancy Vo (WICLOUD CORPORATION) 5,865 Reputation points ā€¢ Microsoft External Staff ā€¢ Moderator

    Hi @David Hill ,

    I wanted to check if there are any updates on your side regarding this issue. Please let me know if you need further assistance. 

Sign in to comment

1 answer

  1. AI answer

    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.
Sign in to answer

Your answer