A
AlexD
How could I check from VB whether a spreadsheet has any
errors?
I'm trying to use
If xlbook.Worksheets(1).Cells(i, j) = "#DIV/0!" Then ...
but the type is mismatched.
The following is not working as well
If xlbook.Worksheets(1).IsError(Cells(i, j)) = True ...
It's a good function (ISERROR) for a spreadsheet but
cannot be used like this in VB(no property).
Can anybody advise anything?
Thanks
errors?
I'm trying to use
If xlbook.Worksheets(1).Cells(i, j) = "#DIV/0!" Then ...
but the type is mismatched.
The following is not working as well
If xlbook.Worksheets(1).IsError(Cells(i, j)) = True ...
It's a good function (ISERROR) for a spreadsheet but
cannot be used like this in VB(no property).
Can anybody advise anything?
Thanks