You could do it this way:

=INDIRECT("Sheet4!"&CHAR(ROW(A1)+65)&"3")

This will start at column B and will work up to column Z - just copy
it down.

Hope this helps.

Pete

On Jan 21, 12:16*am, Craig wrote:
I am trying to copy a formula but I want to keep the row the same and have
the column incrament by one.

Here is an example of what I would like excel to do when I copy the formula
to the cells below.
=+Sheet4!B3
=+Sheet4!C3
=+Sheet4!D3
=+Sheet4!E3

Instead it does this.
=+Sheet4!B3
=+Sheet4!B4
=+Sheet4!B5
=+Sheet4!B6