Thread: [Solved] How to import list from Excel into drop-down list into word
View Single Post
 
Old 11-22-2017, 08:29 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Simply use:
Value:=Trim(.Range("B" & i)) & "|" & Trim(.Range("C" & i)) & "|" & Trim(.Range("D" & i)) & "|" & Trim(.Range("E" & i))
Do be aware, though, that the Value property also has limited capacity.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]