I need to generate a list of six digit numbers 0-9. No number is repeating and each six digit number has a 7, 1, 0, and 3 included in no particular order. Please help with step by step instructions. Thank you!
I need to generate a list of six digit numbers 0-9. No number is repeating and each six digit number has a 7, 1, 0, and 3 included in no particular order. Please help with step by step instructions. Thank you!
when you say "no number is repeating" do you mean in your list or within the 6 digits? ie can you have 710375?
I am not able to help with this, but onteh face of it, pj, I would have to say - no you cant have that because 7 is repeated
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thanks for responding PJ! No numbers repeating at all within the six digits.
Put this in a standard module, do Alt+F8, and run macro JDPB. Results appear in A1:A10800.
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
Hi shg....You are wonderful!!! Only problem is....I am a computer illiterate woman. I am sorry to ask you this and if you wouldn't mind?.....can you explain in dummy terms how to get Standard Module and so on? I appreciate your help ( :
Do Alt+F11 to open the visual basic editor. Insert > Module, paste the code in the window that opens.
Alt+Q to return to Excel.
The resulting workbook must be saved as an xlsm file to preserve the code.
... or see the attached workbook.
Thank you sooooo much shg!!! I am your #1 fan! You are selfless and kind. I am very grateful
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks