Hi All
Row 6:6 contains a mixture of cells containing text and formula that return numbers. I wish to count the either the number of numbers or the number of non empty cells.
The number of non blank cells, either with text(or a formula returning text is constant at 3) or a number (varies) is 7. Therefore the number of rows containing a number atm is 4
What I don't understand is why I'm getting diferent results...
In the worksheet cell formula =COUNTIF(6:6,">0") - this returns 4
When I try to use VBA to do the same thing I get a different answer...
this returns 1
As does
Is it to do with Rows? When I've used these in columns before they have returned the correct answers..
Sorry if I'm just being stupid...
Row 6:6 contains a mixture of cells containing text and formula that return numbers. I wish to count the either the number of numbers or the number of non empty cells.
The number of non blank cells, either with text(or a formula returning text is constant at 3) or a number (varies) is 7. Therefore the number of rows containing a number atm is 4
What I don't understand is why I'm getting diferent results...
In the worksheet cell formula =COUNTIF(6:6,">0") - this returns 4
When I try to use VBA to do the same thing I get a different answer...
Code:
Check_1 = Application.WorksheetFunction.CountIf(Sheets(Which_Sheet).Range("6:6"), ">0")
this returns 1
As does
Code:
Check_2 = Worksheets(Which_Sheet).Range("6:6").Cells.SpecialCells(xlCellTypeConstants).Count
Is it to do with Rows? When I've used these in columns before they have returned the correct answers..
Sorry if I'm just being stupid...