I am working on building a macro to manipulate some data in a spreadsheet that is downloaded. What I need to do is acquire the following information:
the contents of the first cell in column A that contains "clock:"[variable] I will want to store the [variable], as well as the row, which I will name Beginclockrow. The cell will contain the characters "clock:" followed by 3 characters.....
so i have the initial range select for the first cell in column a that has "clock:'
then I start a loop......ending at the last row on the sheet
Next I need to scan down column a, and find the next occurrence of "clock:" if the [variable] has not changed, I will keep looping until it changes. This becomes the next array element, with a new clockname, and beginclockrow.........this also gives me the Endclockrow for the previous array element
So my array in my mind looks like this:
clockarray (clockname, beginclockrow, endclockrow)
My question is how do I dimension the array and redimension it as it needs to grow, it is OK if I have to redim in as I find each new occurance at each loop since I don't know the size going in.