![]() |
|
#10
|
|||
|
|||
|
Hi,
I modified your code. Instead of using a "Array" I have the code look in column G for blanks. The I joined the data from column A to E. See code in "Mod1run" for sheet1. I remarked where I made a change. I remarked the code you had. |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Use Two (concatenate) Fields If Condition Is Met (If... Then... Else)
|
SoonerLater | Mail Merge | 1 | 09-30-2015 05:40 PM |
| how to concatenate text box on new slide | wichitawx | PowerPoint | 5 | 05-19-2015 05:17 AM |
Concatenate with @ symbol
|
anickles | Excel | 2 | 02-06-2015 09:39 AM |
Concatenate if in descending order
|
pgeorgilas | Excel Programming | 2 | 12-10-2014 01:35 AM |
| If, move and concatenate in VBA | devcon | Excel Programming | 0 | 07-04-2011 12:44 AM |