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

K

Kshipra

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Moving extra characters to a new column 18
Test if a string contains only whitespaces 8
VBA formula strings longer than 255 characters 3
Trouble with 255 characters max in a cell 3
How to find row with more than 255 characters in a cell 4
Send parameters in worksheet button > 255 characters 0
String data more than 200 characters in a cell 1
Opening Word Docs from Excel VBA With full path and name > 255 chars 0

Top