Dear All
My requirement is to count the number of cells which are
blank in a excel column, for taht i am writing the following
code;;;;;;;;;;;;;;;;;

private void ValidateReviewComment()
{
//Range xlsRng = _sheet.get_Range("G1",Type.Missing).EntireColumn;
//MessageBox.Show(xlsRng.EntireColumn.Count.ToString ());
Range xlsRng = _sheet.UsedRange;
MessageBox.Show("xlsRng.Rows.Count "+xlsRng.Rows.Count.ToString());
for (int i = 2; i <= xlsRng.Rows.Count; i++)
{

if(xlsRng.Cells.Value2==null)
{
MessageBox.Show(i.ToString());
}
}
}

kindly assist me
thanks
shantanu

I converted your C code to VBA

Sub ValidateReviewComment()
'Range xlsRng = _sheet.get_Range("G1",Type.Missing).EntireColumn;
'MessageBox.Show(xlsRng.EntireColumn.Count.ToStrin g());

Lastrow = Cells(Rows.Count, 1).End(xlUp).Row
Set xlsrange = Range(Cells(1, 1), Cells(Lastrow, 1))

BlankCount = 0
MsgBox ("LastRow = " & Val(Lastrow))
For Each cell In xlsrange

If IsEmpty(cell.Value) Then
BlankCount = BlankCount + 1
MsgBox ("BlankCount = " & Val(BlankCount))
End If
Next cell

End Sub


"shantanu" wrote:

Dear All
My requirement is to count the number of cells which are
blank in a excel column, for taht i am writing the following
code;;;;;;;;;;;;;;;;;

private void ValidateReviewComment()
{
//Range xlsRng = _sheet.get_Range("G1",Type.Missing).EntireColumn;
//MessageBox.Show(xlsRng.EntireColumn.Count.ToString ());
Range xlsRng = _sheet.UsedRange;
MessageBox.Show("xlsRng.Rows.Count "+xlsRng.Rows.Count.ToString());
for (int i = 2; i <= xlsRng.Rows.Count; i++)
{

if(xlsRng.Cells.Value2==null)
{
MessageBox.Show(i.ToString());
}
}
}

kindly assist me
thanks
shantanu

On Apr 3, 4:04 pm, Joel wrote:
I converted your C code to VBA

Sub ValidateReviewComment()
'Range xlsRng = _sheet.get_Range("G1",Type.Missing).EntireColumn;
'MessageBox.Show(xlsRng.EntireColumn.Count.ToStrin g());

Lastrow = Cells(Rows.Count, 1).End(xlUp).Row
Set xlsrange = Range(Cells(1, 1), Cells(Lastrow, 1))

BlankCount = 0
MsgBox ("LastRow = " & Val(Lastrow))
For Each cell In xlsrange

If IsEmpty(cell.Value) Then
BlankCount = BlankCount + 1
MsgBox ("BlankCount = " & Val(BlankCount))
End If
Next cell

End Sub



"shantanu" wrote:
Dear All
My requirement is to count the number of cells which are
blank in a excel column, for taht i am writing the following
code;;;;;;;;;;;;;;;;;

private void ValidateReviewComment()
{
//Range xlsRng = _sheet.get_Range("G1",Type.Missing).EntireColumn;
//MessageBox.Show(xlsRng.EntireColumn.Count.ToString ());
Range xlsRng = _sheet.UsedRange;
MessageBox.Show("xlsRng.Rows.Count "+xlsRng.Rows.Count.ToString());
for (int i = 2; i <= xlsRng.Rows.Count; i++)
{

if(xlsRng.Cells.Value2==null)
{
MessageBox.Show(i.ToString());
}
}
}

kindly assist me
thanks
shantanu- Hide quoted text -

- Show quoted text -

sorry did not help
Thanx a lot i had the solution