Index outside named range does not result in error?!

[ssteenstraten]

Dear all,

I make use of a large number of named ranges which I define and use in my vba code.

The strange thing is that when select an index from the range which is outside the range it doesn't present an error. Instead it selects the first cell in the next row.

Example:

Named_Range A1:A3
Named_Range.Cells(1) = A1
Named_Range.Cells(2) = A2
Named_Range.Cells(3) = A3
Named_Range.Cells(4) = B1 ?!

Does anybody know why this happens and how to prevent it from happening?

Thanks a bunch.

Sander

[p24leclerc]

Did a test on Excel 2010 and it works properly. It does not return an error but the value returned is EMPTY.
Can't help about 2007, sorry.

[Izandol]

The Cells property will refer to cells starting from the specified cell or range - or the first cell of a multiple cell range. It is not limited to only cells within the range unless you are using a For Each loop.