By Shozib on Sunday, 03 June 2018
Posted in Excel
Replies 0
Likes 0
Views 3.3K
Votes 0
Hi everyone
I am trying to send data from excel sheet to word document.
The data is going perfectly, the only problem is when I send the data to word the aliment in word document gets messed.
Please help with my main problem of alignment.

Thanks
Shozib

This is the code which I am using.

Private Sub CommandButton2_Click()
Dim objWord As Object
Set objWord = CreateObject("Word.Application")

Sheet1.Range("F1:Q72").Copy
With objWord
.Documents.Add
.Selection.Paste
.Visible = True
End With

Set objWord = Nothing

End Sub
View Full Post