Redim and Redim Preserve Dynamic Arrays Explained in Excel VBA - Code Included

Thank you very much for this! You give excellent descriptions and use even better examples!

Limitation 1: Can only ReDim Preserve Last Dimension

Thanks for a quick, concise, and clear explanation!

Thanks for this... I needed a quick reference because I forgot how to do this properly and you explained nicely. CHEERS!

How can I redim and existing array to add more elements if I want to put free up some space inside it? If I have a 2 dimensional array with dates and numbers and want to add a certain number of additional dates at the end and then move the values starting at a certain date to later. For example, if there are 100 dates with values and I want to bring it to 110, starting at the 75th date. I'd want to add 10 more dates and then have the array empty from space 75 to 85 and what used to be in 75 start in 85. Does that make sense?

I have cells that I’ve put into a multidimensional array. One of the columns has formulas in it. I need to add the values of those formulas to the values of other columns on the same row in the array. Only problem is when I pass it back to the spreadsheet I have issues. If I feed all the formulas in as values then I get the values in the result column but the formulas are now values in my range on the spreadsheet. If I pass it into the array as formulas my result column calculates wrongly off it and I get formulas in my result column (which I don’t want there, just want the values in that column and the formulas in the other). Any advice on how I can pass my formulas into an array add them to values in another column in the array and put back the formulas as formulas and the values that came from adding the formula to the column as values?

Thanks for this. How would you code this if you wanted to populate darray(3) with "Test" and then ReDim Preserve so that darray(1) and darray(2) are erased but darray(3) is preserved? Thanks

can this redim thing be apply for 2D arrays?