The Reaper
New Member
- Joined
- Mar 21, 2012
- Messages
- 14
I have the following already performing the concatenation of the columns I need, and its working flawlessly, however I need to insert a period "." in between each concatenated item (addresses) but I'm new to Evaluate & having difficulty. Every time I try to put & ""."" & it gives me a #Value error.
Any help is appreciated
Here's my code:
Any help is appreciated
Here's my code:
Code:
Dim WLDfla as long, WLDperf as long
Dim r as range
WLDperf = Sheet1.Cells(Sheet1.Rows.Count, "B").End(xlUp).Offset(1, 0).Row
WLDfla = Sheet1.Cells(Sheet1.Rows.Count, "B").End(xlUp).Row
Set r = Sheet1.Range("A" & WLDperf, "A" & WLDfla)
r.Value = Evaluate(r.Offset(0, 3).Address & "&" & r.Offset(0, 7).Address & "&" & r.Offset(0, 6).Address & "&" & r.Offset(0, 1).Address & "&" & r.Offset(0, 2).Address)