• simple vba (off97)

    Author
    Topic
    #374851

    Hello,

    I am trying to write a little vba to standardise my header/footers. Does anybody know how I put a carriage return in using vba?

    What I have so far is:

    ActiveSheet.PageSetup.RightFooter = “&F &A”

    gives filename then tab, but I would like tab underneath filename.

    Can anyone help?

    Jonathon

    Viewing 1 reply thread
    Author
    Replies
    • #607784

      “&F” & vbLf & ” &A”

      vbLf is “visual basic Line feed”.

      P.S. watch the spacing on headers and footers which use more than one line.

    • #607822

      Jonathan..

      I use this…

      & Chr(10)

      Dennis

      gramps

    Viewing 1 reply thread
    Reply To: simple vba (off97)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: