Skip to main content
Support is Offline
Today is our off day. We are taking some rest and will come back stronger tomorrow
Official support hours
Monday To Friday
From 09:00 To 17:30
  Sunday, 03 June 2018
  0 Replies
  3.1K Visits
0
Votes
Undo
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
There are no replies made for this post yet.