Transferring data from excel to Word and finding alignment problem in Word

  • 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

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!