Question
Create a nested-loop program (you can use any type of loop you would like). This nested loop should take the names input (below) and print
Create a nested-loop program (you can use any type of loop you would like). This nested loop should take the names input (below) and print out every possible combination of first and middle names. These input names will need to appear in your workbook somewhere. (Make sure you type the list of first and middle names in your workbook) Then, output every possible combination of first and middle names somewhere in the worksheet. Your program should work correctly with more or less first names and middle names. Below is an example input and output. To save space, only the names associated with the first two first names are shown in the example output.
To explain some more, take 'Penelope' from the first name list and combine it with all middle names in the range and continue till there are no more names in the range of first names.
First names | Middle names |
Penelope | Jill |
Gwyneth | Diane |
Alice | Heidi |
Anna | Lilly |
Victoria |
Please Post a Screenshot of the VBA code
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started