| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Best way to check if cell is empty??
I currently use the following code to test if a cell is empty:
If IsEmpty(Sheet1.Range("A1").Value) then ' code here End If Are there better or other ways to check if a cell is empty??? Also, does it matter if I put the ".Value" at the end of the Range("A1") code? thankx |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Best way to check if cell is empty?? | Excel Programming | |||
| check for empty cell | Excel Programming | |||
| How do I check for an empty cell in a formula? | Excel Discussion (Misc queries) | |||
| How to check for next empty cell in list | Excel Programming | |||
| vba - check if cell is empty | Excel Programming | |||
Threaded Mode
