Search for part of a string in a range and insert value.

[DaveUK]

Please could someone tell me how to do the following in VBA.
I have searched for a solution all to no avail.

I want to search column D on a worksheet from D3 to the last row of data in column D.

I want to search for "ML" occuring in each cell in the range (as above). If "ML" occurs in the active cell i then want to put "MAIN LINE" into the G column on the same row and then continue searching until an empty cell is found in Column D.

Please note i need to find "ML" even if it is embedded by other letters/numbers BUT only if they occur as "ML".
Eg.

VALID 225ML , 6ML, MLSB, T6ML3 etc

Many Thanks for any advice.

[/code]

 

[babycody]

Book3
	D	E	F	G
1	225ML			MAIN LINE
2	6MdL
3	MLSB			MAIN LINE
4	T6ML3			MAIN LINE
5
Sheet3

This formula doesn't search for the last used row in a range, but it does what you want otherwise.

 

[Zack Barresse]

Please stay to one topic: http://www.mrexcel.com/board2/viewtopic.php?t=180330