Excel VBA error. Complie error: Wrong number of arguments or invalid code assignment

Question

I have been using a recorded Excel macro in Excel to reformat text and columns.  It has worked perfectly for months until today when the error below is produced.  I'm not a coder but I think this must be something simple I'm missing.

Any suggestions?

Frank

Answer 1

When I pasted your code I found the following in a few instances.

I removed the extra line feet space and the macro worked OK

Hi Jeovany,

this issue is due to the new forum editor. Please have a look at this article:
https://answers.microsoft.com/en-us/msoffice/forum/all/vba-issues-with-new-forum-editor/5081b294-7ea7-4a86-870f-6b2834a0653b

And the bug with "columns" in Franks code looks like a symthom of a missing reference to me, I would request the file.

Andreas.

Answer 2

Thank you Andreas

Now I got it.

Regards

Jeovany

Answer 3

Hi Andreas

It's reassuring to know my issue was caused by a bug that my long and scruffy macro highlighted.

So the macro ran as normal when I tried on my laptop. I installed the Office apps on both machines at the same time. How can I find the version numbers? I presume they will be different and one PC has been updated since the install.

Frank

Answer 4

How can I find the version numbers?

Frank,

What do the version numbers help you? Not helpful for me in this case.

If the file works on another machine means the issue is not due to the code or the file.

I suggest to perform an online repair.

Repair an Office application - Office Support

Andreas.