Range limit conundrum

by

I think the magical function you’re looking for here is Union(). It’s built into Excel VBA, so look at the help for it. It does just what you’d expect.

Loop through your ranges, but instead of building a string, build up a multi-area Range. Then you can select or set properties on the whole thing at once.

I don’t know what (if any) the limit on the number of areas you can build up in a single Range is, but it’s bigger than 600. I don’t know what (if any) limits there are on selecting or setting properties of a multi-area Range either, but it’s probably worth a try.

More Related Contents:

  1. Format Cell Contents
  2. Excel formula checklist in employees
  3. How do I put double quotes in a string in vba?
  4. Excel VBA – How to add dynamic array formula
  5. How can I URL encode a string in Excel VBA?
  6. Compare double in VBA precision problem
  7. Row count on the Filtered data
  8. VBA – Write all possible combinations of 4 columns of data [duplicate]
  9. Remove duplicates from array using VBA
  10. Obtain attribute names from XML using VBA
  11. Paste Excel range in Outlook
  12. Return RGB values from Range.Interior.Color (or any other Color Property)
  13. Translate text using vba
  14. Run-time error ‘1004’ : Method ‘Range’ of object’_Global’ failed
  15. “Can’t find Project or Library” for standard VBA functions
  16. How do I issue an HTTP GET from Excel VBA for Mac
  17. Copy sheet and get resulting sheet object?
  18. Sending mail using Outlook where the Send method fails
  19. How do I apply a SumIf Formula in a VBA Sub? Getting Error 1004
  20. Using a variable for row in (row,column) for a range in VBA
  21. Export chart as image – with click of a button
  22. Unicode string literals in VBA
  23. Error13 in Excel VBA in data file
  24. How to get the path of current worksheet in VBA?
  25. Excel VBA to match and line up rows
  26. Change font color for a part of text in cell
  27. Create a new object using the text name of the class
  28. Excel cell from which a Function is called [duplicate]
  29. How to extract text within a string of text
  30. GET pictures from a url and then rename the picture

Leave a Comment