View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kshipra Kshipra is offline
external usenet poster
 
Posts: 6
Default 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?