+ Reply to Thread
Results 1 to 5 of 5

vba code to concatenate text at each end of page report from right to left page

  1. #1
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    MS365
    Posts
    1,079

    vba code to concatenate text at each end of page report from right to left page

    I have a sheet of several pages from report where I concatenate page and page no from column H and I to column A .

    Actually doing this manually

    Looking for a vba solution
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,465

    Re: vba code to concatenate text at each end of page report from right to left page

    This should do
    Please Login or Register  to view this content.

  3. #3
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,777

    Re: vba code to concatenate text at each end of page report from right to left page

    Try:
    Please Login or Register  to view this content.
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

  4. #4
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    MS365
    Posts
    1,079

    Re: vba code to concatenate text at each end of page report from right to left page

    jindon & Mumps1 thank you both for solution provided
    Worked as requested

  5. #5
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,777

    Re: vba code to concatenate text at each end of page report from right to left page

    Glad it worked out.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Help with an existing VBA code to transfer data to 1st page then to overflow page 2.
    By ElmerFud in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-20-2016, 11:53 AM
  2. Replies: 4
    Last Post: 08-28-2014, 02:23 AM
  3. [SOLVED] Vba code to start page numbers from current page (bottom of the pate right side)
    By satputenandkumar0 in forum Word Formatting & General
    Replies: 2
    Last Post: 04-04-2014, 01:09 AM
  4. Replies: 3
    Last Post: 10-11-2010, 12:01 PM
  5. Printing one page grayscale and one page color with code
    By 2funny4words in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-28-2009, 12:27 PM
  6. Login to Web Page and the Search Page for Text
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-19-2006, 10:55 AM
  7. How do I save one page out of a 80 page report in excel?
    By bellamere in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 02-15-2006, 04:30 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1