Thank you very much Leith Ross,
Sorry to disturb you again. I changed the below lines in the code:
Set Found = PartRngWorkbook1DRAMSheeta.Find(cs.Value)
If Found Is Nothing Then GoTo NextCell Else Cell1 = Found.Row
Set Found = PartRngWorkbook1DRAMSheetb.Find("WS Group Totals:", Range("B", Cell1))
If Found Is Nothing Then GoTo NextCell Else Cell2 = Found.Row
Now it is breaking at the line:
If Found is Nothing then GoTo NextCell Else Cell2=Found.Row
It is throwing up the error 'Application or Object defined error"...
Bookmarks