See enclosed file.
I dont understand why my code does not work. In this example i am trying to find the contents of cell A1. But for some reason the formatting of this cell prevents me from finding a match the text string.....any ideas how to get around this because in my main program i need to be able to find these header strings.
Last edited by welchs101; 11-14-2011 at 01:06 PM.
Hi
You have a line feed (ascii 10) in the string so it doesn't match the string you have put into the variable string_to_find.
If you make it
then it will bring back 1 as I think you expect.
Please Login or Register to view this content.
rylo
Last edited by rylo; 11-10-2011 at 11:32 PM.
thanks. that worked just as i hoped it would.
But how did you know what character value to use? How did you know there was even a character you needed to insert?
thanks
adding the Chr(10) does solve the problem.
however, when i try to add the following line of code i get a compile error ......any ideas why?
Please Login or Register to view this content.
Hi
1) Know character was there - experience, and as the text is line wrapped, then a line feed was the first choice.
2) If you don't know what the ascii code is, then try the formula. This will bring back the 10.Please Login or Register to view this content.
3) compile error. From the help file on const
ryloYou can't use variables, user-defined functions, or intrinsic Visual Basic functions (such as Chr) in expressions assigned to constants.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks