Cells.Find() Raises “Runtime Error 91: Object Variable or With Block Not Set”

by

If the string you’re looking for isn’t found you’ll get that error. The find function returns “Nothing” if nothing is found

    Dim r As Range

    Set r = Cells.find(What:=strCliBoa, After:=ActiveCell, LookIn:=xlFormulas, _
    LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
    MatchCase:=True, SearchFormat:=False)

    If r Is Nothing Then
        'handle error
    Else
        'fill in your code
    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. Using VBA in Excel to Google Search in IE and return the hyperlink of the first result
  10. How to put a tooltip on a user-defined function
  11. If WorkSheet(“wsName”) Exists [duplicate]
  12. How to merge rows in a column into one cell in excel?
  13. Autofilter with column formatted as date
  14. Excel vba refresh wait
  15. How to delete multiple rows without a loop in Excel VBA
  16. Excel vba to create every possible combination of a Range
  17. Excel VBA: getting row of clicked button [duplicate]
  18. Excel VBA Filter Change event handler
  19. How to copy only values in excel vba from a range?
  20. How to suppress Update Links warning?
  21. How do we use restful APIs from Excel macros (vba)?
  22. Run a Macro from Another Workbook
  23. Cannot VBA write data to cells in Excel 2007/2010 within a function
  24. Sorting a dictionary by key in VBA
  25. Handle “No cells were found” error when filtered range is empty
  26. Excel: the Incredible Shrinking and Expanding Controls [closed]
  27. How to send email to multiple recipients with addresses stored in Excel?
  28. Generate Word Documents (in Excel VBA) from a series of Document Templates
  29. Using Excel VBA Macro To Capture + Save Screenshot of Specific Area In Same File
  30. How to protect Excel workbook using VBA?

Leave a Comment