I need to create a Left forumla which is created within a macro and placed in cell I2 and autofilled to the variable number z + 1.
The left forumla needs to add together the value in cell J2 and the value K2. However i need to cut the value in J2 so the result is only 7 characters long.
I think its should look like the following but I think this take the character off the end of the string instead of the first.
PPCWBSht.Range("J2").forumla = "=Left(J2 & K2,7)"Can anyone help me?