Excel VBA – select multiple columns not in sequential order

by

Range("A:B,D:E,G:H").Select can help

Edit note: I just saw you have used different column sequence, I have updated my answer

More Related Contents:

  1. SumIf using Excel VBA
  2. Test or check if sheet exists
  3. Copy from one workbook and paste into another
  4. How to copy Outlook mail message into excel using VBA or Macros
  5. For Loop not fully cycling in excel VBA [duplicate]
  6. Unique Random Numbers using VBA
  7. Populate unique values into a VBA array from Excel
  8. Excel VBA App stops spontaneously with message “Code execution has been halted”
  9. Closing Excel Application using VBA
  10. How to clear memory to prevent “out of memory error” in excel vba?
  11. Delete Row based on Search Key VBA
  12. How to add a button programmatically in VBA next to some sheet cell data?
  13. What are the benefits of setting objects to “Nothing”
  14. How can I kill task manager processes through VBA code?
  15. VBA: Usage of parentheses for a method
  16. Fully reference a worksheet by codename
  17. OnTime for less than 1 second without becoming Unresponsive
  18. Get Unicode characters with charcode values greater hex `FFFF`
  19. How do I click a link on a web page using Excel VBA?
  20. Ping IP Address with VBA code and return results in Excel
  21. VBA copy cells value and format
  22. Multiply Entire Range By Value?
  23. VBA Excel – IFERROR & VLOOKUP error
  24. Finding a workbook in one of multiple Excel instances
  25. How to check whether certain sheets exist or not in Excel-VBA? [duplicate]
  26. Application.WorksheetFunction.Match method
  27. Excel – Using COUNTIF/COUNTIFS across multiple sheets/same column
  28. Excel Hide/Show all tabs on Ribbon except custom tab
  29. Macros Not Showing Up in Macro Table
  30. Excel telling me my blank cells aren’t blank

Leave a Comment