Put this in the start cell (where you want: =B4)
=INDIRECT("B"&ROWS($1:1)*2+2)
Copy down as far as required
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,000 Files:359 Subscribers:56
xdemechanik
---
"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!