+ Reply to Thread
Results 1 to 4 of 4

Autofill using range (x)

  1. 10-01-2014, 10:14 PM #1
    weeeee0713
    weeeee0713 is offline
    Registered User
    Join Date
    08-03-2014
    Location
    Philippines
    MS-Off Ver
    Microsoft Office 2010
    Posts
    43

    Angry Autofill using range (x)

    Good Morning, Anyone can help me to solve my problem on the autofill step? I have error encounter which is the range(x). Anyone know the correct code for it? Thanks Thanks.


    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 10-01-2014, 10:38 PM #2
    humdingaling
    humdingaling is offline
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Autofill using range (x)

    what are you actually trying to do?
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
    Reply With QuoteRegister To Reply
  3. 10-01-2014, 10:48 PM #3
    Vikas_Gautam
    Vikas_Gautam is offline
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Re: Autofill using range (x)

    Try this ( will do I hope )

    Please Login or Register  to view this content.
    Regards,
    Vikas Gautam
    Excel-buzz.blogspot.com
    Excel is not a matter of Experience, its a matter of Application.
    Say Thanks, Click * Add Reputation
    Reply With QuoteRegister To Reply
  4. 10-01-2014, 10:53 PM #4
    Vikas_Gautam
    Vikas_Gautam is offline
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Re: Autofill using range (x)

    Make sure one thing.. your syntax should be equivalent to..
    Source_Range.Autofill Destination:=Destination_Range
    See the following example..
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Selecting Range for Autofill: Select Last range.
    By enyak in forum Excel General
    Replies: 1
    Last Post: 06-19-2014, 11:43 PM
  2. Need help on set range and autofill
    By chriskingkiller in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-07-2013, 05:28 AM
  3. [SOLVED] Very small AutoFill macro showing "AutoFill methode of range class failed" why ?
    By nur2544 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-28-2013, 10:21 PM
  4. autofill in macro range is constant- how can I code to be a variable range?
    By mcg7@ntrs.com in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-20-2010, 12:44 AM
  5. Autofill range
    By jprockjr in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-10-2010, 05:34 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1