Check if Cells A2 and A3 are blank in Excel

Question

I tried this code:

public static void CellsBlank()
{

Worksheet worksheet;

Workbook wb = Global.Variables.GlobalVariables.oXL.ActiveWorkbook;

Excel.Range cell1 = (Excel.Range)worksheet.get_Range("A2", "A2");

Excel.Range cell2 = (Excel.Range)worksheet.get_Range("A3", "A3");
}

But that throws a debug error when it hits my Excel.Range cell1 line! How should I re-write this?

Vulpes · Answer

Try: public static bool CellsBlank() { Worksheet worksheet; Workbook wb = Global.Variables.GlobalVariables.oXL.ActiveWorkbook; worksheet = wb.ActiveSheet; if (worksheet != null) { Excel.Range cell1 = worksheet.get_Range(A2 A2); Excel.Range cell2 = worksheet.get_Range(A3 A3); if(cell1.Value2 == null && cell2.Value2 == null) { return true; } } return false; }

Vulpes · Answer

Yes except that since it's a method you need to specify the parentheses in C#: if (CellsBlank()) Also if you might want to test cells other than A2 and A3  then you could pass them as parameters to the method.

richard smith · Answer

And to check the outcome in my code I would use: if (CellsBlank == true) { //run the code for when cells are blank } else //run the code for when cells are NOT blank } Is that correct?