Excel: How to check if a cell is empty with VBA? [duplicate]

by

You could use IsEmpty() function like this:

...
Set rRng = Sheet1.Range("A10")
If IsEmpty(rRng.Value) Then ...

you could also use following:

If ActiveCell.Value = vbNullString Then ...

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. Test or check if sheet exists
  4. How can I find last row that contains data in a specific column?
  5. Copy from one workbook and paste into another
  6. How to copy Outlook mail message into excel using VBA or Macros
  7. Open Excel file for reading with VBA without display
  8. For Loop not fully cycling in excel VBA [duplicate]
  9. Excel VBA App stops spontaneously with message “Code execution has been halted”
  10. How to return the number of dimensions of a (Variant) variable passed to it in VBA [duplicate]
  11. How to remove all non alphanumeric characters from a string except period and space in excel?
  12. Find last used cell in Excel VBA
  13. Does Dir() make any guarantee on the order of files returned?
  14. Call a Sub with a String
  15. How to clear memory to prevent “out of memory error” in excel vba?
  16. Assign on-click VBA function to a dynamically created button on Excel Userform
  17. ShowAllData method of Worksheet class failed
  18. Faster way to remove ‘extra’ spaces (more than 1) from a large range of cells using VBA for Excel
  19. Extract Data from Word Document to an Excel SpreadSheet
  20. Excel macro -Split comma separated entries to new rows [duplicate]
  21. VBA equivalent to Excel’s mod function
  22. Get text from clipboard using GetText – avoid error on empty clipboard
  23. Benchmarking VBA Code
  24. Display milliseconds in Excel
  25. VBA editor auto-deletes spaces at the ends of lines
  26. Select entire column in table using Excel VBA
  27. Application.Quit command not closing the entire Excel Application
  28. Reducing WithEvent declarations and subs with VBA and ActiveX
  29. Trying to open the workbook in separate instance
  30. Function Overloading and UDF in Excel VBA

Leave a Comment