formula creating

[referrrrrr]

Hi, please help with the following:

I have formula that refers to one cell (lets say A5=B3). When i copy formula
from A5 to A6 (down verticaly), A6 refers to B4 (reference shifts down too).

What should I do to make reference to shift horizontaly? (after copying
formula verticaly to A6, reference should shift horizontaly to C3, not
verticaly to B4) Is this possible and how?

[Bob Phillips]

See response in worksheet.functions

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"referrrrrr" <[email protected]> wrote in message
news:[email protected]...
> Hi, please help with the following:
>
> I have formula that refers to one cell (lets say A5=B3). When i copy
formula
> from A5 to A6 (down verticaly), A6 refers to B4 (reference shifts down
too).
>
> What should I do to make reference to shift horizontaly? (after copying
> formula verticaly to A6, reference should shift horizontaly to C3, not
> verticaly to B4) Is this possible and how?