I have a cell which contains a formula. Is there an easy way to change it
to a value without doing a paste(special)?
Also I have failed to be able to work out how to easily do a Vlookup based
upon this cell and to replace it with a new value without copying it to a
new cell and then referencing the lookup from that one? Underlying all this
I have been trying to set a variable to the cell value and then doing a
lookup using the variable but the syntax would'nt work??
A green one!

Hi Mervyn

Check out this page for examples that are using the Value property.
http://www.rondebruin.nl/values.htm

You second quistion I thinkk I don't understand but

=VLOOKUP(C1,A1:B8,2)
In this formula is the value in C1 the variable lookup value

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Mervyn Thomas" wrote in message ...
I have a cell which contains a formula. Is there an easy way to change it
to a value without doing a paste(special)?
Also I have failed to be able to work out how to easily do a Vlookup based
upon this cell and to replace it with a new value without copying it to a
new cell and then referencing the lookup from that one? Underlying all this
I have been trying to set a variable to the cell value and then doing a
lookup using the variable but the syntax would'nt work??
A green one!