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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!