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.
For better understanding the question, the attachment is uploaded.
The red line in Word attachment, is showing the problem.
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