I'm trying to fill a dynamic array from a range but am having problems.
The active sheet is 'Temp' and I'm trying to fill the array (scrNum) with values in the range J4 to U4 from the sheet 'MeetData'.
About half the time there will be no entries in the range, so the array will be empty, other times there will be 1 or more numbers. The cells are filled from left to right, so the first empty cell marks the end of data in the range.
I tried using Worksheets("MeetData").Range("J4", "U4").Count to get the size of the array (is this correct?), but get lost when trying to actually fill it with the data. Should I be selecting the start of the range ("J4") then using offsets to specify the data or is there a simpler/better way?
TIA
Bookmarks