Assign numbers 101 - 106

When the value QUAR is found I want to number the values like I have below. They will only appear in the configuartion below. But can be anywhere in My Range



I'm trying to turn this :

QUAR QUAR QUAR QUAR QUAR QUAR QUAR QUAR
QUAR QUAR QUAR QUAR QUAR QUAR QUAR QUAR
QUAR QUAR QUAR QUAR QUAR QUAR QUAR QUAR
QUAR QUAR QUAR QUAR QUAR QUAR QUAR QUAR
QUAR QUAR QUAR QUAR QUAR QUAR QUAR QUAR
QUAR QUAR QUAR QUAR QUAR QUAR QUAR QUAR

In to this:

QR101 QR101 QR101 QR101 QR101 QR101 QR101 QR101
QR102 QR102 QR102 QR102 QR102 QR102 QR102 QR102
QR103 QR103 QR103 QR103 QR103 QR103 QR103 QR103
QR104 QR104 QR104 QR104 QR104 QR104 QR104 QR104
QR105 QR105 QR105 QR105 QR105 QR105 QR105 QR105
QR106 QR106 QR106 QR106 QR106 QR106 QR106 QR106

Hi

assuming the data starts from A1

Please Login or Register  to view this content.

rgds,
jindon

The actual range is G11:CX290

would I use that in place of r.?

Thanks for oyur help

Nevermind, I understand the range now. But one question how do I make it restart when it gets to 106, I don't to get any higher than that.

Thanks