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!