+ Reply to Thread
Results 1 to 3 of 3

VBA Code - Autofill with a Dynamic Range

  1. #1
    Registered User
    Join Date
    07-24-2013
    Location
    Kuala Lumpur
    MS-Off Ver
    Excel 2003
    Posts
    2

    VBA Code - Autofill with a Dynamic Range

    Hi guys,


    I will make my issue as quick and concise as possible. I have the following code:

    Please Login or Register  to view this content.
    As you can see I have currently set the range to Q500. I would need the autofill destination to be dynamic, depending on what is entered in the cell marked "Tenure" in Excel. For example if the tenure cell value is 10, I want the range to be: Range("A17:Q[Tenure*12+15]), so Range("A17:Q135"). To help, I had the previous copy paste code that worked but was too slow:

    Please Login or Register  to view this content.

    How do I specify that range with autofill? Any assistance appreciated,


    thank you,


    Jurij

  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 365 on Win11 (desktop), 2019 on Win11 (notebook)
    Posts
    8,199

    Re: VBA Code - Autofill with a Dynamic Range

    Hi, Jurij,

    Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

    Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

    Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

    Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

    http://www.vbaexpress.com/forum/show...-Dynamic-Range

    related thread: http://www.mrexcel.com/forum/excel-q...and-macro.html

    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  3. #3
    Registered User
    Join Date
    07-24-2013
    Location
    Kuala Lumpur
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: VBA Code - Autofill with a Dynamic Range

    Sorry, I was in a hurry and needed to get the answer, will not happen again in the future. The problem is resolved now. Thank you,

    Jurij

+ 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. VBA code to autofill until dynamic cell
    By JPSN in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-11-2013, 06:59 AM
  2. Need a macro to autofill a dynamic range
    By missmea2005 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-13-2012, 09:15 AM
  3. Vlookup and autofill a dynamic range
    By ajay1967 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-20-2012, 07:36 PM
  4. Autofill using Dynamic Range (Last Column) and Last Row
    By goldenr2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-05-2011, 11:21 PM
  5. Macro Autofill Dynamic Range with Multiple Data Sets
    By AliveNThisMoment in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-07-2010, 03:46 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