zoso
Well-known Member
- Joined
- Oct 23, 2003
- Messages
- 725
Hi there!
I was given the following line as part of a sub:
I need to understand what this actually does.
I was wanting a match to be found by looking through all text entries with no limit to the number of characters in the cell and I suspect the above line is incorrect.
At the moment my sheet is being pasted with rogue text entries that are all greater than 255 characters, and I think it has something to do with this line
If you need me to post more I will - hope you can help!
I was given the following line as part of a sub:
Code:
FindWhat = Left(Target.Value, 255)
I was wanting a match to be found by looking through all text entries with no limit to the number of characters in the cell and I suspect the above line is incorrect.
At the moment my sheet is being pasted with rogue text entries that are all greater than 255 characters, and I think it has something to do with this line
If you need me to post more I will - hope you can help!