Thanks for the tip. I had tried that, but it didn't work.

I have managed to get around this problem by naming the cell which
allows me to enter values into it and use
range("whatever").offset("whatever").name = "myname" to change the
cell, which for most purposes works. Unfortunately I need to use the
line:

activecell.value=activecell.value

the reason I need to use this is that I am trying to plot a curve and
the cells that the X-axis values are taken from contain excel function
and for some reason the values are plottes in the order they are in (ie
1, 2, 3, 4, ) instead of the value in the cell. Apparently if I use

activecell.value=activecell.value

It will convert the cell from text to numbers.

I anyone can shed some more light on the situation with this added
info, it would be very handy.


--
biosci
------------------------------------------------------------------------
biosci's Profile: http://www.excelforum.com/member.php...o&userid=32827
View this thread: http://www.excelforum.com/showthread...hreadid=530296