Excel VBA Array
Posted on 2013-11-20
I am using VBA in Excel 2010 and have an array called HeadingLocation defined with 11 locations (0-10). I have a loop filling the array locations with row values.
Now I want to select a range from one array position to another, eg:
Range ("A" & HeadingLocation(0) & ":A" & HeadingLocation(1)).Select
As I loop around I want to change the array location to match the loop cycle, eg first loop array position 0 to 1, second loop position 2 to 3 etc.
I would appreciate help in getting the array locations to change on each loop, all my attempts are failing :( Many thanks