Hi
Im trying to place a row of data into an array if it contains a 2013 in the date cell.
My problem is resizing the array to add a new row in the variant where the next data will go.
The resize happens and i have Var(1) and var(2), but when
the For loop runs for the next record, the second var (var(2)) is deleted! i tried using an integer eg var(i)
and incrementing i through each loop but i keep getting a subscript out of range error! (second block of code)
What is happening is, Var(1) is continously being overwritten, and Var(2) has "empty" in all its "cells".
What am i missing?
thanks
My attempt at including an incrementing integer
Bookmarks