Get length of array?

by

Length of an array:

UBound(columns)-LBound(columns)+1

UBound alone is not the best method for getting the length of every array as arrays in VBA can start at different indexes, e.g Dim arr(2 to 10)

UBound will return correct results only if the array is 1-based (starts indexing at 1 e.g. Dim arr(1 to 10). It will return wrong results in any other circumstance e.g. Dim arr(10)

More on the VBA Array in this VBA Array tutorial.

More Related Contents:

  1. Non-web SQL Injection
  2. Trying to use variables as values vba to sql
  3. How to insert an embedded picture?
  4. Error: “Could Not Find Installable ISAM”
  5. Rounding in MS Access
  6. Comparison of Dictionary, Collections and Arrays
  7. How to query a MS-Access Table from MS-Excel (2010) using VBA
  8. What is the different between IsNull, IsEmpty, =Empty, and an empty string ie “” and why might I use variants
  9. we want to search for an empty column and add items to that column using a vba form
  10. Error in finding last used cell in Excel with VBA
  11. What is the difference between dim and set in vba
  12. Quicker way to get all unique values of a column in VBA?
  13. How to set recurring schedule for xlsm file using Windows Task Scheduler
  14. Change date format using substitute or replace
  15. VBA: Convert Text to Number
  16. Concatenate cell data into another data if values matches
  17. Iterating through populated rows
  18. Using VBA to detect which decimal sign the computer is using
  19. Loop through each row of a range in Excel
  20. How to send mail when the .Send does not work?
  21. Get Unicode characters with charcode values greater hex `FFFF`
  22. How do I click a link on a web page using Excel VBA?
  23. Ping IP Address with VBA code and return results in Excel
  24. VBA copy cells value and format
  25. Paste Excel Chart into Powerpoint using VBA
  26. running excel macro from another workbook
  27. Multiply Entire Range By Value?
  28. EXCEL VBA UserInterfaceOnly:= True not working
  29. VBA Excel – IFERROR & VLOOKUP error
  30. Finding a workbook in one of multiple Excel instances

Leave a Comment