Macro is not placing Chr letter as it suppose to accoring to code

[nosense]

The code below suppose to fill in the given range (myrange) with a name (specified in Sheets("Machining").Range("J10")) and letters starting from an "A" (Chr(56)) and finish at the letter corresponding to whatever end of range is.
Instead it is placing the letters as of Row 9 i.e. if my IF match is at row 11 then it will put C,D,E .. and so on instead of starting with an "A"

Please Login or Register  to view this content.

[Norie]

Don't use i for the letter part, use another variable.

Please Login or Register  to view this content.

[nosense]

Don't use i for the letter part, use another variable.

Please Login or Register  to view this content.

AWESOME! This worked Rep to you