L
Legacy 365210
Guest
Hi all, I have a dynamic variant array that is populated via a table column in a sheet. I need to add to this array with the contents of a column in another sheet. I would post the current code but on my mobile at the mo.
The 2 columns in question change values on a daily basis so I have simply set the upper bound of my array to a counta for the first column contents on redim (so 1 to counta). I can easily set the ubound to be counta column 1 + counta column2 but I can't for the life of my see how to tell the array to populate from BOTH the different sheet columns. Anyone had this problem before?
The 2 columns in question change values on a daily basis so I have simply set the upper bound of my array to a counta for the first column contents on redim (so 1 to counta). I can easily set the ubound to be counta column 1 + counta column2 but I can't for the life of my see how to tell the array to populate from BOTH the different sheet columns. Anyone had this problem before?
