VBA-If More than same ID in serach-find different Row.

[JediJim]

Guys-Looking to get information from highlighting the field"TCPAM ETC" then finding all the information relating to that. It only picks up one Row, should I use a loop to get data from the next Row?

If WorksheetFunction.CountIf(Sheets("MO Trade List").Range("A2:A15"), "TCPAM Investments (Cayman) Limited - MENA Equity Fund") > 1 Then
With Sheets("MO Trade List").Range("A2:A15")

Thanks,

JJ