'Yesterday, we learned how to create a basic array in Excel VBA. 'Today we are going to actually do something with it. 'Let's highlight the rows of the people that are over 35. Here we go. Sub CollectRowValuesInAnArray() Dim startrow As Long Dim lastrow As Long Dim myArray() Dim a As Long Dim i As Long Dim myRowValue As String Dim myColumn As Long 'In your dim statements add Dim myRow As Long Dim mySecondRowValue As String Dim myThirdRowValue As String dim myName as string dim myAge as long dim myFood as string 'set your startrow to the begining of your row data 'this...

Most design software output's to Microsoft Excel in some form or fashion. In this 2 part tutorial, I will show you how to collect an array of cell values in M$oft Excel VBA. There a few ways to loop through each row in excel VBA. For me, the quickest way is to dump the data into an array. 1. Open your excel spreadsheet. 2. Save it as another file name so you don't inadvertently mess something up while you're playing. Here is mine: 3. Open the VBA Editor (Press Alt+F11) 4. Create a new Module 5. Paste in the code below sub CollectRowValuesInAnArray() dim startrow as long dim...