I am facing problem in writing macro / vb code in excel.

It is not allowing me to copy more than 256 chars of a cell.

Is there any solution to this problem??