What does ReDim Preserve do?

by

Redim Preserve allows you to change the dimensions of an array while keeping the contents of the array.

The Redim Preserve at the end of each loop is adding another row to the array.

I think the second loop is appending to the array because the i variable is not changed between the loops.

More Related Contents:

  1. How do I get values from a hidden worksheet using VBA [closed]
  2. How to copy cells that contain certain text to another worksheet [closed]
  3. VBA Macro for copying and pasting columns on same excel sheet
  4. Excel VBA, code to count the # of filled cells, then find highest and 2nd highest and subtract the corresponding column #’s [closed]
  5. Levenshtein Distance in VBA [closed]
  6. VBA Runtime Error 1004 “Application-defined or Object-defined error” when Selecting Range
  7. Assign event handlers to controls on user form created dynamically in VBA
  8. Programmatic Access To Visual Basic Project Is Not Trusted
  9. Can I make this macro more efficient or faster?
  10. Conditional Formatting using Excel VBA code
  11. Controlling IE11 “Do you want to Open/Save” dialogue window buttons in VBA
  12. How to get the background color from a Conditional Formatting in Excel using VBA
  13. VBA Excel Populate ListBox with multiple columns
  14. VBA Integer Overflow at 70,000
  15. How to count up text of a different font colour in excel
  16. How to “flatten” or “collapse” a 2D Excel table into 1D?
  17. VBA Macro to compare all cells of two Excel files
  18. VBA: Else without If Error
  19. Workbooks.Open Method in VBA
  20. How to highlight a cell using the hex color value within the cell?
  21. Convert RTF (Rich Text Format) code into plain text in Excel
  22. lastrow and excel table.
  23. Creating form programmatically in the module using vba
  24. Find and FindNext for Excel VBA
  25. Iterating through all the cells in Excel VBA or VSTO 2005
  26. How can I display my windows user name in excel spread sheet using macros? [closed]
  27. How does Excel’s worksheet password protection work
  28. Hiding active workbook programmatically in Excel
  29. Excel VBA Project has generated multiple Workbook objects
  30. How to find a value in an excel column by vba code Cells.Find

Leave a Comment