Hi.
I need a VBA script to find five-digit numbers where the five-digit number is the addition of each digit raised to the power of 5.
I mean: vwxyz= (v^5)+(w^5)+(x^5)+(y^5)+(z^5) where vwxyz is just the numbers themselves not the product.
I would like to execute it in a cycle to see the other solutions.
Thanks
Last edited by Paul.127; 09-21-2011 at 12:05 PM.
Do you need VBA? or would something like this (see attached) suffice?
Here's the VBA code to do it and write the output to the end of column A in sheet 1...
Please Login or Register to view this content.
Hi,
Sounds suspiciously like a homework question but I'll give you the benefit of the doubt
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
If you want to prove you didn't figure it out yourself use:
Please Login or Register to view this content.
Last edited by snb; 09-21-2011 at 06:43 AM.
Masterful! I like itOriginally Posted by snb
I do love snb's code, but I'm puzzled by the paradox that if people follow the advice on line 1 of snb's sig then probably none of it ever gets used, i.e. if you trust everything that snb tells you then you'll never use any of their advice
You can translate the signature also into:
'Please, analyse the code before using it; if you have done so you will have expanded your VBA-coding scope, and be able to adapt the code.'
Now I admire your code AND your optimism
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks