Decomposition in Prime Factors

[philippe1]

Hi,

I am looking for a script to decompose a list of numbers into their prime factors.

Attached is a file with an example of what I am looking for.

Thanks for your help,

Philippe

[arthurbr]

Google search on "decomposition in prime factors +excel" yielded more than 100 k answers -

[shg]

Please Login or Register  to view this content.

E.g.,

Please Login or Register  to view this content.

[philippe1]

Hi,

I tried this code but got this error message: Argument not optional

Any idea of what is wrong?

Philippe

[shg]

"Tried it" in what way?

[philippe1]

I created a module with the code.

Then pressed alt f8 and made the Factors function run.

This is when I received the error message.

[shg]

You used a formula on a worksheet, or wrote code to test it? If the latter, post the code.

[philippe1]

Hi,

I could figure out what what went wrong.

I wasn't applying the function properly in the cells.

Thank you for your patience, sorry I am kind of an absolute beginner in Excel.

Philippe

[shg]

Well done, glad you got it sorted out.

[Captain Pedro]

I clicked select code copied the code then opened a new module in the vb editor and pasted the code in. then selected "close and return to excel" on the file menu. I selected a column of values and pressed Alt+F8 to view macros the macro doesn't appear on the list. So I looked at the code, didn't find "sub Marco_name()" or "end sub" so I deleted that module created a new one and typed "sub prime_factors()" and Enter. Then I pasted the code in between exited to excel and tried to run the macro by selecting a range of values typing "Alt+F8" and got the error "expecting endsub" what am I doing wrong please

[arlu1201]

Captain Pedro,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.