Hey!! Thank you for the reply.

However, you have specified, "If i = 12 Then" which will not always be the case.

It will keep on changing.

The code will not work in that case.

For example. I changed the row number of Part Number R9 (From Row 12 to Row 13), in which case the code failed..