+ Reply to Thread
Results 1 to 4 of 4

Macro auto fill is not working

  1. #1
    Registered User
    Join Date
    05-14-2016
    Location
    Illinois,USA
    MS-Off Ver
    2016
    Posts
    2

    Unhappy Macro auto fill is not working

    Hi all
    I am trying to write for my excel .I am begginer and this first time I tred Macro.
    I wrote this code
    Please Login or Register  to view this content.
    Aecxel code.PNGnd i get this error:Run time error 1004;Select method of rang class failed and the line
    Worksheets("2").Range("C26:D27").Select
    is highlighted
    I have no idea what to do ;can you guys help me thanks

    Ashkan
    Email:[email protected]

  2. #2
    Valued Forum Contributor WasWodge's Avatar
    Join Date
    08-02-2010
    Location
    Hampshire,England
    MS-Off Ver
    Office 365 and Office 2010
    Posts
    882

    Re: Macro auto fill is not working

    You can only use Select on the ActiveSheet.

    You also need to post links on all the sites you have cross-posted on as per most forum rules.

    X-posted here
    If my solution worked (or not) please let me know. If your question is answered then please remember to mark it solved

    Computers are like air conditioners. They work fine until you start opening windows. ~Author Unknown

  3. #3
    Valued Forum Contributor
    Join Date
    06-29-2014
    Location
    Australia
    MS-Off Ver
    MSO 365
    Posts
    1,095

    Re: Macro auto fill is not working

    ............and here

    http://ccm.net/forum/affich-896615-m...is-not-working

  4. #4
    Registered User
    Join Date
    05-14-2016
    Location
    Illinois,USA
    MS-Off Ver
    2016
    Posts
    2

    Re: Macro auto fill is not working

    sorry for that i did nt know

+ 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. Auto fill / flash fill not working with formulas?
    By mhorga in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-18-2016, 12:54 PM
  2. macro to bring up stored workbook, auto save to a new folder, then auto fill
    By Rick23 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-29-2014, 06:58 PM
  3. Auto fill cell based on Drop Down List not working
    By cbcruz in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-14-2014, 10:35 AM
  4. [SOLVED] Formula to auto-fill Index/Match not working
    By rajncajn in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-18-2013, 09:21 AM
  5. Select an item from drop down list and auto fill in next working date
    By pjlau in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-23-2012, 12:49 AM
  6. Auto Fill stopped working...
    By Nickster64 in forum Excel General
    Replies: 1
    Last Post: 04-03-2009, 01:05 PM
  7. Replies: 1
    Last Post: 07-13-2007, 10:59 AM

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