Handle “No cells were found” error when filtered range is empty

by 
Dim rngStart As Range
Dim rngFiltered As Range

'...
'...
Set rngFiltered = Nothing '<<< reset rngFiltered if running this code in a loop...
On Error Resume Next
Set rngFiltered = rngStart.SpecialCells(xlCellTypeVisible)
On Error Goto 0

If not rngFiltered is Nothing then
    rngFiltered.Copy
End If
'...
'...

More Related Contents:

  1. Excel Number Separation [closed]
  2. excel vba compare & copy worksheets from 2 excel files
  3. VBA Stuck after certain loop
  4. How to avoid using Select in Excel VBA
  5. Is the . in .Range necessary when defined by .Cells?
  6. How to return a result from a VBA function
  7. Cycle through sub-folders and files in a user-specified root directory [duplicate]
  8. Convert Text to Date?
  9. Loop through each cell in a range of cells when given a Range object
  10. Checking for #N/A in Excel cell from VBA code
  11. Non-web SQL Injection
  12. Error: “Could Not Find Installable ISAM”
  13. Properly Handling Errors in VBA (Excel)
  14. Is there a way to slow down a Web Scraper so it will pick up the code?
  15. Create a folder and sub folder in Excel VBA
  16. Aggregate, Collate and Transpose rows into columns
  17. One-dimensional array from Excel Range
  18. Renaming Files with Excel VBA
  19. Is there a way to import data from .csv to active excel sheet?
  20. Comparison of Dictionary, Collections and Arrays
  21. Break out of a While…Wend loop
  22. How to add events to dynamically created controls (buttons, listboxes) in Excel VBA userform
  23. How to make safe API Timers in VBA?
  24. VBA paste as values – how to
  25. Excel: the Incredible Shrinking and Expanding Controls [closed]
  26. How to send email to multiple recipients with addresses stored in Excel?
  27. Generate Word Documents (in Excel VBA) from a series of Document Templates
  28. Using Excel VBA Macro To Capture + Save Screenshot of Specific Area In Same File
  29. Type Mismatch in Loop to scan Outlook Messages [duplicate]
  30. How to protect Excel workbook using VBA?

Leave a Comment