This formula references cell B4
and contains no volatile functions
(which re-calc whenever any other cell re-calcs and
can make a workbook sluggish):
A1: =INDEX(B:B,ROWS($1:1)*2+2)

Copy that formula into A2 and down as far as you need
to reference B6, B8....etc

Is that something you can work with?

Regards,

Ron Coderre
Microsoft MVP (Excel)

"jyorraku" wrote in message
...
I have Excel 2002, I need to reference only even number row
coordinates, and I would like to do it with a fill down:

=B4
=B6
=B8
=B10
..
..


But if I select the first two cells and do a fill down, it duplicates
the coordinates?

=B4
=B6
=B6
=B8
=B8
=B10
=B10


HELP!