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]
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]