+ Reply to Thread
Results 1 to 6 of 6

Run time Error '1004' & the drop down menu formula is not working in F16 Columns

  1. #1
    Forum Contributor
    Join Date
    07-21-2014
    Location
    india
    MS-Off Ver
    2007
    Posts
    170

    Run time Error '1004' & the drop down menu formula is not working in F16 Columns

    r/sir
    than i am click on the 'create sales invoice from template button' the run time error 1004 was displayedAttachment 459121, i am insert this formula=OFFSET(Products!$D$5,MATCH($B$16,Category_Full,0),0,COUNTIF(Category_Full,$B$16),1) than i am click on the 'create sales invoice from template button' the template-retail invoice sheet was generated but this formula was not working on F16 Column Drop down Menu please correct all these error sir i am sending the attachments sir
    thanking you sir
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Run time Error '1004' & the drop down menu formula is not working in F16 Columns

    Hi,

    Probably because when your macro encounters this line

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    the variable index "i" has a value of 12 yet there are only 11 names that are scoped to the Settings sheet
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Contributor
    Join Date
    07-21-2014
    Location
    india
    MS-Off Ver
    2007
    Posts
    170

    Re: Run time Error '1004' & the drop down menu formula is not working in F16 Columns

    R/Sir
    these Error was not resolve please resolve these error sir

  4. #4
    Forum Contributor
    Join Date
    07-21-2014
    Location
    india
    MS-Off Ver
    2007
    Posts
    170

    Re: Run time Error '1004' & the drop down menu formula is not working in F16 Columns

    r/sir
    Sales & Purchase Manger Sheets in this excel files in sales manager sheet than i am click on the "Create Sales invoice" "Run time Error '1004' was displayed & than Purchase Manager sheets than i am click on the "Create Purchase invoice" template error "The Templete dose not exist, please make sure the selected templete matchies the name of templete worksheet" was displayed please resolve these error sir please s resolve these issue sir
    thanking you sir i am send the attachments sir
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    07-21-2014
    Location
    india
    MS-Off Ver
    2007
    Posts
    170

    Re: Run time Error '1004' & the drop down menu formula is not working in F16 Columns

    please reply sir

  6. #6
    Forum Contributor
    Join Date
    07-21-2014
    Location
    india
    MS-Off Ver
    2007
    Posts
    170

    Re: Run time Error '1004' & the drop down menu formula is not working in F16 Columns

    please reply sir

+ 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. Replies: 3
    Last Post: 08-07-2015, 04:43 AM
  2. [SOLVED] Run time error (1004), for inserting formula macro
    By missy22 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-21-2014, 06:46 AM
  3. Pivot table source not working run time error 1004
    By vba317 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-23-2014, 04:03 PM
  4. Pivot table source not working run time error 1004
    By vba317 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-22-2014, 05:15 PM
  5. macro to enter array formula not working get error 1004
    By bkwins in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-07-2013, 06:52 AM
  6. run-time error '1004' - advanced filtering not working
    By scubadiver007 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-21-2013, 05:49 PM
  7. Replies: 1
    Last Post: 09-23-2011, 10:35 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