Results 1 to 9 of 9

Dynamic AutoFill Destination Range

Threaded View

  1. #1
    Registered User
    Join Date
    01-13-2016
    Location
    Madrid
    MS-Off Ver
    2013
    Posts
    5

    Dynamic AutoFill Destination Range

    Hi all this is my first post i hope i don't make any mistake,

    I need help with this Macro, I can't don't know how to configure the Autofill Destination range to be the cells on right column to the cells selected in the previous statement.

    Thanks in advance for the help.

    Sub Macro1()
    ' Macro1 Macro
    '
        Range("A50").Select
        Selection.End(xlToRight).Select
        Selection.End(xlToRight).Select
        Range(Selection, Selection.End(xlDown)).Select
        Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove
        Range("A51").Select
        Selection.End(xlToRight).Select
        Range(Selection, Selection.End(xlDown)).Select
        Selection.AutoFill Destination:=Range("Q51:R58"), Type:=xlFillDefault
       
    
    
    End Sub
    Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer
    Last edited by cesrua; 01-19-2016 at 05:44 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copy from static destination & paste to dynamic destination
    By Marbleking in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-31-2015, 09:31 AM
  2. [SOLVED] Autofill Destination Range
    By ERaasio in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-14-2014, 03:02 PM
  3. Autofill a destination range using last row value
    By jaym911 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-29-2013, 12:07 PM
  4. [SOLVED] AutoFill Destination Unknown Range
    By sperry2565 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-08-2013, 04:53 PM
  5. How to extend Range.AutoFill Destination down an addition 3 rows?
    By BBoydAnchor in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-31-2011, 10:51 AM
  6. Autofill in VBA with a dynamic "Destination" range
    By ConneXionLost in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-04-2011, 04:55 PM
  7. Selection.Autofill Destination:=Range(ActiveCell.Value)
    By Shaka215@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-23-2006, 06:20 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