formula creating
 

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?

formula creating
 

See response in worksheet.functions

--

HTH

Bob Phillips

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

"referrrrrr" wrote in message
...
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?