Hi there! I have a vba which adds a formula in I9:last row "=G9&J9". For some reason this formula is not working properly. When I change J9 to Text, then go back into the formula and hit enter it works. Is there a way to resolve this? Or do I need to change J9:last row to Text? If that's the fix, any suggestions how I can do that? I tried the below and visually it changed to text, but didnt correct my formula issues, and i'm calling the conversion before I insert the formula macro:
Thanks!
VBA Code:
'change Contact to Text
ActiveSheet.Range("J9:J" & lastrow).NumberFormat = "@"
VBA Code:
ActiveSheet.Range("I9:I" & lastrow).Formula = "=G9&J9"
Thanks!