How to check for empty array in vba macro [duplicate]

by

As you are dealing with a string array, have you considered Join?

If Len(Join(FileNamesList)) > 0 Then

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. How do I base64 encode a string efficiently using Excel VBA?
  8. Assign event handlers to controls on user form created dynamically in VBA
  9. Programmatic Access To Visual Basic Project Is Not Trusted
  10. Can I make this macro more efficient or faster?
  11. Building Undo Into an Excel VBA Macro
  12. Excel vba add code to sheet module programmatically
  13. Best workaround for VBA Transpose array length limit?
  14. How to Lock the data in a cell in excel using vba
  15. How to use Events with Option Button Controls on Userform [duplicate]
  16. How do I use variables to set properties in VBA (Excel)
  17. VBA: Else without If Error
  18. Workbooks.Open Method in VBA
  19. Windows().Activate works on every computer except one
  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. Open a workbook from VBA and disable Workbook_Open() code?
  24. Creating form programmatically in the module using vba
  25. How to filter listbox values based on a Textbox value
  26. Find and FindNext for Excel VBA
  27. Run-time error ’91’ (Object variable or With block variable not set)
  28. How to have vba execute every 10 minutes?
  29. Read and write from/to registry in VBA
  30. Unable to read data from a CSV using ADO due to the driver thinking I am working with integers/number and showing nulls instead of text

Leave a Comment