If statement - Line needed

[mattress58]

I need to add something on each of the lines that have:

I need to add something to the end that if "42" is found it does the

and also skips all the other

Sheets("sheet2").Range("L16").Select


For b = 22 To 23
Data = Mid(MyHost.Row(b), 1, 2)
If Data = "42" Then
ActiveCell.Value = Mid(MyHost.Row(14), 2, 4)
Else
ActiveCell.Value = Mid(MyHost.Row(14), 2, 4)
RC = MyHost.Runcmd("DOWN")
End If
Next


and picks up at

[jmac1947]

Hi mattress58,

I am not sure i fully understand what you are asking but it seems that if you did something like this you may be heading in the right direction, see one example inside the *************** lines
for example of how I have interpret your request

Please Login or Register  to view this content.

apologies if I am on the wrong path

[mattress58]

Perfect. Thanks