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...