Award Winning Plant Industry Community

Tag: Excel VBA

Excel VBA – Create A Basic Array Part 2

By on June 1, 2011 in Programming, SPPID, Tutorial with 1 Comment

‘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 [...]

Continue Reading »

Excel VBA – Create A Basic Array Part 1

By on May 31, 2011 in Programming, SPPID, Tutorial with 4 Comments
Excel VBA – Create A Basic Array Part 1

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 [...]

Continue Reading »

Top