+ Reply to Thread
Results 1 to 2 of 2

FDF Invoice Select Mulitple Rows

  1. #1
    Registered User
    Join Date
    05-09-2013
    Location
    Miami, Florida
    MS-Off Ver
    Excel 2019 (online)
    Posts
    10

    FDF Invoice Select Mulitple Rows

    I have an excel macro that I am creating for an invoice. The invoice is to ultimately create an FDF file to post to a PDF with fields.

    I only can currently select all items on the same row, but for an invoice I need to be able to select multiple rows of the same column as well as multiple columns within the rows selected (ie. name box "test" =$A$13:$O$20.)

    Currently I am using

    "Select = Range(Selection.Rows & ":" & Selection.Rows)

    Select(1, 17)"

    Which will Select Row 1 (the current row which is selected) & 17 (the column of the row selected)

    I am trying to create it so that I can select any and/or all of the rows and columns in name box "test".

    Thank you.

  2. #2
    Registered User
    Join Date
    05-09-2013
    Location
    Miami, Florida
    MS-Off Ver
    Excel 2019 (online)
    Posts
    10

    Re: FDF Invoice Select Mulitple Rows

    I was able to figure it out:

    instead of

    Select(1, 17)"

    I used

    Range("A13")

    A little bit of a pain at first but once I labeled each cell according to the PDF field then it autopopulates.

    If anyone has a simpler way, please let me know.


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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