Detect if range is empty

by

Found a solution from the comments I got.

Sub TestIsEmpty()
    If WorksheetFunction.CountA(Range("A38:P38")) = 0 Then
        MsgBox "Empty"
    Else
        MsgBox "Not Empty"
    End If
End Sub

More Related Contents:

  1. Is the . in .Range necessary when defined by .Cells?
  2. Convert an entire range to uppercase without looping through all the cells
  3. How to copy only values in excel vba from a range?
  4. Copy a selected range to another worksheet
  5. VBA Dialog box to select range in different workbook
  6. VBA: Modify chart data range
  7. SumIf using Excel VBA
  8. How can I call a macro which contains a loop but only run one iteration of that loop?
  9. Test or check if sheet exists
  10. Copy from one workbook and paste into another
  11. How to copy Outlook mail message into excel using VBA or Macros
  12. For Loop not fully cycling in excel VBA [duplicate]
  13. Unique Random Numbers using VBA
  14. Populate unique values into a VBA array from Excel
  15. Excel VBA App stops spontaneously with message “Code execution has been halted”
  16. How to remove all non alphanumeric characters from a string except period and space in excel?
  17. Closing Excel Application using VBA
  18. How to clear memory to prevent “out of memory error” in excel vba?
  19. Assign on-click VBA function to a dynamically created button on Excel Userform
  20. Checking if a worksheet-based checkbox is checked
  21. Faster way to remove ‘extra’ spaces (more than 1) from a large range of cells using VBA for Excel
  22. Extract Data from Word Document to an Excel SpreadSheet
  23. VBA equivalent to Excel’s mod function
  24. Pointers needed for speeding up nested loop macro in VBA
  25. ‘1004’: “The sort reference is not valid.”
  26. Select entire column in table using Excel VBA
  27. Create hyperlink to another sheet
  28. Reducing WithEvent declarations and subs with VBA and ActiveX
  29. Access files with long paths (over 260)
  30. How to highlight selected text within excel

Leave a Comment