You obviously didn't see Biff's or my reply. Hopefully you can see
this one.

You are trying to access the 61st cell of a range which is only 60
cells long - this is why you are getting the #REF error.

Hope this helps.

Pete

On Mar 21, 8:36*am, please_post_to_groups
<please_post_to_groups@post_post_to_groups_please. com wrote:
Greetings All

sorry if this the second post the first one never made it through...gremlins in the system

I’m getting a strange #ref error message in excel and I’m not sure
why. *Everything works great up to cell and row. *but when I get past
that the #ref error pops up. *Is this a limit to excel 2003? Anyone
have any workarounds or recommendations?

The code I start to get the error at is =INDEX($D$3:$D$62,2*ROWS
($1:31)+COLUMNS($D:D)-2)

An image can be found athttp://test.onewithall.net/problem/excel_problem.jpg
or the Excel file can be found at ishttp://test.onewithall.net/problem/excel_problem.xls

Tia sal2