How to get the range of the visible rows after applying an advanced filter in Excel (VBA)

by 
ActiveSheet.Range("A1:A100").Rows.SpecialCells(xlCellTypeVisible)

This yields a Range object.

More Related Contents:

  1. SumIf using Excel VBA
  2. How can I call a macro which contains a loop but only run one iteration of that loop?
  3. VBA comma separated cells, needt last entry only
  4. How can I find last row that contains data in a specific column?
  5. Copy from one workbook and paste into another
  6. Open Excel file for reading with VBA without display
  7. Wait for shell command to complete [duplicate]
  8. How to return the number of dimensions of a (Variant) variable passed to it in VBA [duplicate]
  9. How to remove all non alphanumeric characters from a string except period and space in excel?
  10. Find last used cell in Excel VBA
  11. VBA general way for pulling data out of SAP [closed]
  12. Does Dir() make any guarantee on the order of files returned?
  13. Call a Sub with a String
  14. Assign on-click VBA function to a dynamically created button on Excel Userform
  15. Using a wildcard to open an excel workbook
  16. How to add parameters to an external data query in Excel which can’t be displayed graphically?
  17. ADODB Connection String for .csv
  18. Pivotfields multiple filter
  19. How to send mail when the .Send does not work?
  20. How to clear memory to prevent “out of memory error” in VBA?
  21. Extract Data from PDF and Add to Worksheet
  22. EXCEL VBA Check if entry is empty or not ‘space’
  23. Change Name of ActiveX Command Button using VBA in Excel
  24. EXCEL VBA UserInterfaceOnly:= True not working
  25. How to implement custom iterable class in VBA
  26. move files from one folder to another
  27. How to find Number of Occurences of Slash from a strings
  28. VBA Excel simple Error Handling
  29. How to do a “Save As” in vba code, saving my current Excel workbook with datestamp?
  30. How to save semi-colon delimited csv file using VBA?

Leave a Comment