handling empty cells when the variable is oher type than string

[Kari Paukku]

Hi,

Is there a better way to program a case when,reading data from an excel-sheet, a cell is empty and the data from the cell should go to a double variable?

This works:
Dim d as double
If sheet.Range(Row, 1).Value <> "" Then
d = sheet.Range(Row, 1).Value
End If

However it would be nicer not to have the if clause.

TIA,
Kari

[Melba Winshia]

Hi Kari,

Use the following code snippets to check if the cell is blank or not.

[VB]
sheet.Range(2, 1).IsBlank = False

Here is the sample for your reference:

Blank.zip

Please take a look at the sample above and let me know if you have any other questions.

Thanks,
Melba