+ Reply to Thread
Results 1 to 6 of 6

Error autofilling on change

  1. #1
    Registered User
    Join Date
    11-26-2013
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    7

    Error autofilling on change

    Hi

    I have a workbook that logs our suppliers problems and I have created the following code

    Please Login or Register  to view this content.
    however occasionally is has an error loop how can i fix this

  2. #2
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Error autofilling on change

    Can you be more specific? What is the error code? What line is highlighted when you debug? How often does it happen?
    Thanks,
    Solus


    Please remember the following:

    1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    Highlight the code in your post and press the # button in the toolbar.
    2. Show appreciation to those who have helped you by clicking below their posts.
    3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

    "Slow is smooth, smooth is fast."

  3. #3
    Registered User
    Join Date
    11-26-2013
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Error autofilling on change

    Hi

    I get a circular reference warning when using, however no error on debug.
    Last edited by mattdurbin; 11-29-2013 at 10:38 AM.

  4. #4
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Error autofilling on change

    I'm guessing the problem is where you're trying to loop through all variants in a range. Like here:
    Please Login or Register  to view this content.
    What exactly are you trying to accomplish?

  5. #5
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: Error autofilling on change

    Perhaps you may try this:
    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    11-26-2013
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Error autofilling on change

    thanks, that solved it

+ 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. [SOLVED] Autofilling Dates
    By Clemson in forum Excel General
    Replies: 5
    Last Post: 08-30-2013, 01:43 PM
  2. Autofilling many rows
    By kbka in forum Excel General
    Replies: 3
    Last Post: 06-28-2011, 07:48 AM
  3. Autofilling VBA
    By Laylow in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-22-2011, 01:48 PM
  4. autofilling formulas
    By k_babb in forum Excel General
    Replies: 2
    Last Post: 05-11-2010, 07:49 AM
  5. When autofilling I would like to change worksheets rather than cel
    By tomsmithers in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-26-2006, 08:08 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