Having a VBA problem when writing an EXCEL macro

Question

Having a VBA problem when writing an EXCEL macro

David Hill 100

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

David Hill 100 Reputation points

2026-06-13T14:44:54.0033333+00:00

I need to send you an EXCEL file so you can understand the problem.
David Hill 100 Reputation points

2026-06-13T14:47:03.49+00:00

How do I send you a simple EXCEL file to illustrate my macro problem ?
Senthil kumar 2,080 Reputation points

2026-06-13T18:27:55.87+00:00

Hi @David Hill

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

Thanks
Nancy Vo (WICLOUD CORPORATION) 8,075 Reputation points Microsoft External Staff Moderator

2026-06-15T06:03:00.45+00:00
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.
Nancy Vo (WICLOUD CORPORATION) 8,075 Reputation points Microsoft External Staff Moderator

2026-06-18T02:21:08.7466667+00:00

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.
David Hill 100 Reputation points

2026-06-18T14:22:56.0566667+00:00

As of this morning (June 18), I have received no solutions to my problem from the user community.
Nancy Vo (WICLOUD CORPORATION) 8,075 Reputation points Microsoft External Staff Moderator

2026-06-19T06:32:14.5066667+00:00
I understand you haven't received a solution yet, but I cannot assist you because I do not have the details of your issue.

For further investigate, please reply directly with:

The specific VBA code you are using (you can copy and paste it here).

The exact error message or unexpected behavior you are seeing.

The detailed description of your issue

Once you provide these details, we will be able to help you fix the macro.
Nancy Vo (WICLOUD CORPORATION) 8,075 Reputation points Microsoft External Staff Moderator

2026-06-23T03:33:22.6566667+00:00

Hi @David Hill ,

Just checking in to see if you had a chance to review my previous response. Please feel free to reach out if you have any questions - I’m here to help.
Nancy Vo (WICLOUD CORPORATION) 8,075 Reputation points Microsoft External Staff Moderator

2026-06-25T02:22:47.25+00:00

Hi @David Hill ,

Since I haven’t received any recent updates, I’ll go ahead and close this thread for now. If you still need assistance, please feel free to reach out at any time. I’ll be happy to help.

Thank you.

2 answers

Your answer

David Hill 100 Reputation points

2026-06-13T14:44:54.0033333+00:00

I need to send you an EXCEL file so you can understand the problem.
David Hill 100 Reputation points

2026-06-13T14:47:03.49+00:00

How do I send you a simple EXCEL file to illustrate my macro problem ?
Senthil kumar 2,080 Reputation points

2026-06-13T18:27:55.87+00:00

Hi @David Hill

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

Thanks
Nancy Vo (WICLOUD CORPORATION) 8,075 Reputation points Microsoft External Staff Moderator

2026-06-15T06:03:00.45+00:00

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.
Nancy Vo (WICLOUD CORPORATION) 8,075 Reputation points Microsoft External Staff Moderator

2026-06-18T02:21:08.7466667+00:00

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.
David Hill 100 Reputation points

2026-06-18T14:22:56.0566667+00:00

As of this morning (June 18), I have received no solutions to my problem from the user community.
Nancy Vo (WICLOUD CORPORATION) 8,075 Reputation points Microsoft External Staff Moderator

2026-06-19T06:32:14.5066667+00:00

I understand you haven't received a solution yet, but I cannot assist you because I do not have the details of your issue.

For further investigate, please reply directly with:

The specific VBA code you are using (you can copy and paste it here).

The exact error message or unexpected behavior you are seeing.

The detailed description of your issue

Once you provide these details, we will be able to help you fix the macro.
Nancy Vo (WICLOUD CORPORATION) 8,075 Reputation points Microsoft External Staff Moderator

2026-06-23T03:33:22.6566667+00:00

Hi @David Hill ,

Just checking in to see if you had a chance to review my previous response. Please feel free to reach out if you have any questions - I’m here to help.
Nancy Vo (WICLOUD CORPORATION) 8,075 Reputation points Microsoft External Staff Moderator

2026-06-25T02:22:47.25+00:00

Hi @David Hill ,

Since I haven’t received any recent updates, I’ll go ahead and close this thread for now. If you still need assistance, please feel free to reach out at any time. I’ll be happy to help.

Thank you.

Answer 1

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:

A short description of what the macro should do and what actually happens.
Any error messages, including the exact text and when they appear.
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.
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:

Answer 2

Hi @David Hill,

You cannot directly upload or attach raw Excel files (.xlsm or .xlsx) here due to security and platform limitations. However, you can share your problem and code using the following alternative methods:

Upload your sample Excel file (make sure to remove any sensitive or personal data) to a cloud drive like OneDrive, Google Drive, or Dropbox.

Generate a shared link (set it to "Anyone with the link can view").

Paste that link here in a comment or update your question.

If the problem is purely with the macro code:

Press ALT + F11 in Excel to open the Visual Basic Editor.

Copy the specific Sub or Function code that is causing the error.

Paste it here using the Code Block ({}) tool in the formatting toolbar so it's readable.

You can take a screenshot of the error message or your data layout and upload it directly using the Insert Image icon in the reply editor.Hi @David Hill,

You cannot directly upload or attach raw Excel files (.xlsm or .xlsx) here due to security and platform limitations. However, you can share your problem and code using the following alternative methods:

Upload your sample Excel file (make sure to remove any sensitive or personal data) to a cloud drive like OneDrive, Google Drive, or Dropbox.

Generate a shared link (set it to "Anyone with the link can view").

Paste that link here in a comment or update your question.

If the problem is purely with the macro code:

Press ALT + F11 in Excel to open the Visual Basic Editor.

Copy the specific Sub or Function code that is causing the error.

Paste it here using the Code Block ({}) tool in the formatting toolbar so it's readable.

You can take a screenshot of the error message or your data layout and upload it directly using the Insert Image icon in the reply editor.

Having a VBA problem when writing an EXCEL macro

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

2 answers

Method 1: Share via Cloud Storage (Recommended)

Method 2: Share the VBA Code Directly

Method 3: Share Screenshots

Method 1: Share via Cloud Storage

Method 2: Share the VBA Code Directly

Method 3: Share Screenshots

Your answer