Column A,B consists of First and Last Names.
Column A Column B
I would like to pick the name value and generate a statement like in column J:
My Name is Frank Doe
My Name is Joe Smith
I ended up using a formula inside a For Loop; but with compile and run time errors.
For cnt = selectednumber To lastrownumber
Range("J" & cnt).Formula = "=""My name is (""& $A &cnt & $b &cnt ""."""
Any help is appreciated.