Question: Part A: School List Create a range variable (named rngIndex) that represents the list of numbers in column A of the Data sheet. SET that
Part A: School List Create a range variable (named rngIndex) that represents the list of numbers in column A of the Data sheet. SET that variable to cells A2 to A21 of the Data sheet but DO NOT hardcode the reference. Use a combination of Offset and End(xlDown) to determine the current size of the range. Loop through each cell in rngIndex and create a string variable (strList) that shows the AlphaOrder, Name and Mascot where mascot is in uppercase. (Use UCASE function.) Display that string in a message box as in the example >> Attach the code to this button to execute. Lines of code needed: about 10
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
