Hello!
I am not an Excel expert and looks like I faced very simple problem.
May be somebody can help me with that,please?

a)I create an array of data in worksheet. Let say:
1 2
3 4
b) I name the cell where the first element is as "first" (Left apper
corner of a worksheet allows to label a particular cell, like
A1-"first")
c) Then I name a new cell with the label "ar" and insert a matrix
formula there {=OFFSET(first,0,0,1,1)}. At this step I assume that my
named cell "ar" represents the array with 2 rows and 2 columns. I also
see the first array value in this cell like "1" (Not a #VALUE, not a
#NAME)
d) If in any cell of the worksheet I'll use the formula =ROWS("ar") it
shows "1". But it should be "2".

What I am missing?

I am using MSExcel 2000 and XP platform. Did I forget to include some
add-ins in the project in order to work with matrix formula?

Thanks a lot,
Sergey