How do i find a cell that contains more than 255 characters
 

Hi,

while working with excel, i've following problems.
1) I have string contains more than 255 characters which sometimes i'm
unable to assign in a cell through VBA.

2) If my cell contains more than 255 characters i'm getting a "Type
mismatch" error in "sheet.cells.find".
I can't use any wild card characters as i don't have an unique data.

Is there any workaround for the same?