it does not make any difference.

thanks though
"R.VENKATARAMAN" &&& wrote in message
...
where is the entry
in your case try
cells(2,25)=cells(2,2)
does it help?
cells(2,2) has already data and cells(2,25) is blank
so you configure that cells(2,25) willhave the value of cells(2,2)


Bob Taylor wrote in message
...
I get the error #VALUE! as a result of the following VB code Cells(2,
2)
=
Cells(2, 25).

according to the examples and the books this should work and is very
easy,
but i can not make it work, the cell types are both GENERAL and the
contents are strings. i have tried string to string and using ranges and
everything else that i can find and nothing allows me to move the
contents
of one cell to another. it has to be a simple answer.