LittleGriff
New Member
- Joined
- Jan 13, 2012
- Messages
- 11
I'm trying to join the contents of two columns, and have the new string appear in a third. It looks great when I use Debug.Print, but I can't get the new string to appear in the third column.
Here's my print statement, which works great:
The Column AJ holds the numeric value, AK holds the phrase that starts with "From." I've been able to add the text and parens properly.
Here's what shows up in Immediate, as I loop through my rows:
6 months (From initial closing)
6 months (From final closing)
5 months (From initial closing)
6 months (From commencement date)
How do I get "AJ & i" plus "AK & i" into the third cell, "AL and i"?
Thank you!
Here's my print statement, which works great:
Code:
Debug.Print Worksheets("TEST").Range("AJ" & i).Value; " months (" & Worksheets("TEST").Range("AK" & i).Value; ")"
The Column AJ holds the numeric value, AK holds the phrase that starts with "From." I've been able to add the text and parens properly.
Here's what shows up in Immediate, as I loop through my rows:
6 months (From initial closing)
6 months (From final closing)
5 months (From initial closing)
6 months (From commencement date)
How do I get "AJ & i" plus "AK & i" into the third cell, "AL and i"?
Thank you!