"cyberdude" wrote:
I have a spreadsheet in which
cell C2 contains =A1,
cell C3 contains =A3,
cell C4 contains =A5
may I know what operation I can do, without using
macro, such that cell C5 contains =A7, cell C6
contains =A9, cell c7 contains =A11 etc?

Try a different approach. Enter the following formula in C2 and copy down:

=INDEX(A:A,2*ROWS($C$2:C2)-1)