Thread: [Solved] Need macro to fill the values in msword based on the excel sheet info
View Single Post
 
Old 08-24-2018, 12:21 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,465
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
Yet another difference you failed to mention...

To deal with that, you might change:
.Cell(x, 2).Range.Text = "PV: " & xlWkSht.Range("B" & r).Value
to:
.Cell(x, 2).Range.InsertAfter xlWkSht.Range("B" & r).Value
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote