Absolute ref

  • Thread starter Thread starter Sadik
  • Start date Start date
S

Sadik

Hi All,

I have a custom function in the following form:

Function Test(A,B,C)

Users select A, B and C, enter the function in say B1 and
then copy it down the column. What I am looking for is a
way to make A as absolute and B and C reletaive reference.
One way is that the user inserst $ signs manually. Is
there another way? Can i do it automatically?

(I asked this question in another MS group sometimes ago
with no workable answer)

Thanks for your help.

Regards

Sadik
 
Hi
instaed of inersting the '$' sign manually the user can hit F4 to
toggle between absolute and relative references.
 
Back
Top