Inconsistent Performance of cells.value text

**rzrbkpk** · 02-06-2014, 12:49 PM

I've been using a procedure for over a year without any issues, but ran into one today with the following section

Please Login or Register  to view this content.

The code could not find the "Lead Case Manager(s)" field in the range, but it exists. I checked previous data for comparison and there is no difference. So I copied the cell text directly into my code and it works now. Again, I compared the text in the old code to what I just copied into it and it's exactly the same.

Does anyone have an explanation for this?

**LJMetzger** · 02-06-2014, 01:50 PM

Hi,

Make sure the field doesn't have any leading or trailing spaces or other non-printable characters.

Instead of the construction you use try:

Please Login or Register  to view this content.

Lewis

**Leith Ross** · 02-06-2014, 01:57 PM

Hello rzrbkpk,

Difficult to say what the problem was. In my experience, I have seen where headers get corrupted by other users doing copy and paste operations. Other times, people accidentally add a space at the end of header or even a tab name. To avoid space problems, I make it a habit to use the Trim function before doing a compare on either headers or sheet names. Using Select ... Case can make you code easier to read and maintain.

Please Login or Register  to view this content.

**rzrbkpk** · 02-06-2014, 02:13 PM

LJMetzger and Leith thanks for the responses. I checked for the leading/trailing spaces and there were none. I will try using both methods suggested for improving my code. I didn't consider use the .text property for the cell. May be possible that the data in the header changed to another format.