retaining a value

Hi

You can do this with vb

lets say the value you want is in A1 and we will save them in col z

sub sheet_change()
if target.column = 1 and target.row = 1 and target.value<>FALSE
range("Z65536").end(xlup).offset(1,0).formulaR1C1 = target.value
else
end if

end sub

HTH

Jacob

Not sure I follow completely. You want to retain the value from where? If the value is from H1, then you could just do =if(H1=1,255,H1). If you want it to give a different value for a different number, you could add the "or" function, or you could create a table and use a lookup formula. If this doesn't help, give me some more details, examples, of what you're trying to do.

Thanks for a quick reply Scott. Again setting the h1 column = to the entered value 1(hard entry) in another cell I have a formula like =if(h1=1,255) which will give me in the formula cell the value 255. I need someway to be able to take this value and put it in another cell so that the value of 255 becomes a hard type entry that will not change depending on what happens in the formula cell. ie h1 will now become anothe entry like 2 and the formula cell will now be equal to another value. Of course the if statement will be constructed to detect what the value i wish to store is. formula cell would be similar to =if(h1=1,255,h1=2,260). I just need to be able to get the figures swlected by the h1 cell so as the don't interact as h1 changes.I know these values will need to be in a cell other that the formula cell. Hope this is a little clearer.

It looks like that might work but i've to do a little reading on implementing vb scripts.I can tell by you reply that it looks like it would work. Thanks for your help.