fix a cell

[G2K]

Hi,

I want to freege a cell by the value entered in last cell i.e. left adjucent cell, and i want this value fix even i drag to right like

<TABLE dir=ltr borderColor=#000000 cellSpacing=0 cellPadding=2 width=156 border=1><TBODY><TR><TD width="19%" height=6>

c2​

​

​

​

​

</TD><TD width="23%" height=6>

d2​

​

​

​

​

</TD><TD width="19%" height=6>

e2​

​

​

​

​

</TD><TD width="19%" height=6>

f2​

​

​

​

​

</TD><TD width="19%" height=6>

g2​

​

​

​

​

</TD></TR><TR><TD width="19%" height=6>

25​

​

​

​

​

</TD><TD width="81%" colSpan=4 height=6>

formula to acess c2 and fix it​

​

​

​

​

</TD></TR></TBODY></TABLE>

if i drag this formula to it's right adjucent cell, value will remain same

thanks

 

[Aladin Akyurek]

Hi,

I want to freege a cell by the value entered in last cell i.e. left adjucent cell, and i want this value fix even i drag to right like

<TABLE dir=ltr border=1 cellSpacing=0 borderColor=#000000 cellPadding=2 width=156><TBODY><TR><TD height=6 width="19%">c2

​

</TD><TD height=6 width="23%">d2

​

</TD><TD height=6 width="19%">e2

​

</TD><TD height=6 width="19%">f2

​

</TD><TD height=6 width="19%">g2

​

</TD></TR><TR><TD height=6 width="19%">25

​

</TD><TD height=6 width="81%" colSpan=4>formula to acess c2 and fix it

</TD></TR></TBODY></TABLE>​

if i drag this formula to it's right adjucent cell, value will remain same

thanks

Do you mean something like:

=INDIRECT("C2")

 

[G2K]

yes, but i don't want to use absolute reference as i an using macro to insert columns. if i use indirect it always use C2, even there is 5 columns inserted inbetween.

is there any other way to fix .....

 

[Aladin Akyurek]

yes, but i don't want to use absolute reference as i an using macro to insert columns. if i use indirect it always use C2, even there is 5 columns inserted inbetween.

is there any other way to fix .....

Perhaps I'm not understanding what you mean by "fix a cell"...

Does...

=INDEX(C:C,2)

do what you need?

 

[G2K]

Thanks Aladin,

I got the formula

Offset(c1,1,-1)

thanks again for your time and support

 

[Aladin Akyurek]

Thanks Aladin,

I got the formula

Offset(c1,1,-1)

thanks again for your time and support

Index would be better for it's not volatile.

 

[G2K]

i have entered this formula in cell c1 itself and it's working

=OFFSET(c1,0,-1)