can a string be too long?

[melliot2]

Dim ph as String
ph= "PH (LC)"
If InStr(Cells(1, c), ph) Then ph = Cells(1, c)

I am trying to use formula. It works great when the contains cell is short. as in one line in the formula bar. However sometimes it will be much longer up to four lines in the formula bar. Would the lenghth cause it to not set the ph variable to the entire cell contents?

 

[Rick Rothstein]

Dim ph as String
 
ph= "PH (LC)"
If InStr(Cells(1, c).Value, ph, vbTextCompare) Then ph = Cells(1, c).Value

That last statement should be this...

If InStr(1, Cells(1, c).Value, ph, vbTextCompare) Then ph = Cells(1, c).Value

If you specify the 'compare' argument, then you must include the 'start' argument as well; if you only include three arguments, InStr automatically assumes the first argument is the 'start' argument (followed by the two string arguments).

 

[shg]

My bad, thanks, Rick.