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.ToString());

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 <J...@discussions.microsoft.com> wrote:
> I converted your C code to VBA
>
> Sub ValidateReviewComment()
> 'Range xlsRng = _sheet.get_Range("G1",Type.Missing).EntireColumn;
> 'MessageBox.Show(xlsRng.EntireColumn.Count.ToString());
>
> 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