Dynamic Range Name Anomalities
Hi Arishy,
I am assuming that with the result you are getting that you have the
workbook saved in 97-2003 format. Also I would expect the result to be 65534
not 65531.
Reason is that your countif counts all cells < "x" in column A and it will
include all of the blank cells because none of the blank cells are equal to
"x".
--
Regards,
OssieMac
"Arishy" wrote:
Created A Dynamic range with this formula
=offset(sheet1!$a$1,0,0,countif(sheet1!$a:$a,"<x" ),1) call it
MyRange
Col A:
1 AAA
2 BBB
3 CCC
4 x
5 x
IF I go to VBA and use Immediate Windows and I type:
? Range("MyRange").Rows.Count ................... I get
65531 ( I am using Excel 2007 )
My logic tells me it should be 3
Now if I go to A6 and type =CountIF(a1:a5,"<x")
I get 3
Can someone enlighten me ????
.
|