Award Winning Plant Industry Community

Tag: compare

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 »

Top