Column(A1)-1

always returns zero
when you copy it to the right, the A1 changes to B1 and the result is a 1,
the C1 and the result is a 2.

Multiplied by 2 and offset from A1 this produces

A1, C1, E1, G1
in successive cells

you said you wanted

A1 C1 E1 G1 ...

--
Regards,
Tom Ogilvy


"dmsalvay1978"
wrote in message
news:dmsalvay1978.1ulnuj_1125443120.8717@excelforu m-nospam.com...

Tom,

I just figured it out. It took me a while to realize that I had to
change the number I was subtracting the from COLUMN() function
depending on what my start column was. Thanks so much!

--David


--
dmsalvay1978
------------------------------------------------------------------------
dmsalvay1978's Profile:
http://www.excelforum.com/member.php...o&userid=26801
View this thread: http://www.excelforum.com/showthread...hreadid=400568