how to check if a cell is populated or not?

  • Thread starter Thread starter Francesco Sblendorio
  • Start date Start date
F

Francesco Sblendorio

If IsEmpty(xbook.Application.Cells(I, 1)) Then
' do stuff...
End If
 
Hello there
I am using a nested loop to read from an Excel workbook.
When I reach the first unused Cell, an "Object reference not set to an
instance of an object" error is generated.
How do I check if the cell if used or not?
I tried:
xbook.Application.Cells(I, 1).value().ToString.Length <> 0
xbook.Application.Cells(i, 1).value() = Nothing
and both did not work.
Any ideas?
Regards
Sameh
 
Hi
try
If IsEmpty(xbook.worksheets("sheet1").Cells(I, 1)) Then
' do stuff...
End If
 
I am working on .net visual basic
i added
Imports Microsoft.Office.Interop.Excel
but i still give the error; Name 'isempty' is not declared.
any ideas?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
Mandatory cells only if another cell is filled 0
Use IsEmpty on a range without a loop? XL03 3
Snag in invoice generator. How to change the "series" 5
Best way to check if cell is empty?? 1
Trying to run excel vba code when cell value changes from empty to entered value. 1
Runtime error 1004 when trying to insert formula in cells 11
Populating a range of empty cells with usernames 4

Back
Top