+ Reply to Thread
Results 1 to 4 of 4

Help w/ Autofill Marcos

  1. #1
    Forum Contributor
    Join Date
    01-20-2015
    Location
    NB, Canada
    MS-Off Ver
    365
    Posts
    164

    Help w/ Autofill Marcos

    Right now my macros has a hard cell for the end of the auto fill
    data is in a table and I would like it to go to the end of the table, so I can add, or subtract rows to the table.

    Current code line:

    Selection.AutoFill Destination:=Range("I3:P9397")

  2. #2
    Registered User
    Join Date
    05-14-2020
    Location
    Mauritius
    MS-Off Ver
    Office 365
    Posts
    97

    Re: Help w/ Autofill Marcos

    Hello,

    you must check first for the last used row. This you can store in a LONG variable. Then use this variable in your code line instead of the 9397:

    Please Login or Register  to view this content.
    Greetings

    Tor


  3. #3
    Forum Contributor
    Join Date
    01-20-2015
    Location
    NB, Canada
    MS-Off Ver
    365
    Posts
    164

    Re: Help w/ Autofill Marcos

    Perfect.
    Thank you sir.

  4. #4
    Registered User
    Join Date
    05-14-2020
    Location
    Mauritius
    MS-Off Ver
    Office 365
    Posts
    97

    Re: Help w/ Autofill Marcos

    You are welcome

+ 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. Hey, I'm Marcos
    By kosteraku in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 04-01-2020, 11:01 PM
  2. Marcos
    By Bernie Deitrick in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 07:05 PM
  3. Marcos
    By cjloneranger in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 11:05 AM
  4. [SOLVED] Marcos
    By Bernie Deitrick in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2005, 07:05 AM
  5. Marcos
    By cjloneranger in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  6. [SOLVED] Marcos
    By cjloneranger in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  7. [SOLVED] Marcos
    By cjloneranger in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM

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