+ Reply to Thread
Results 1 to 2 of 2

Worksheet_Change Looping (Why?)

  1. 03-14-2014, 12:45 PM #1
    batchy
    batchy is offline
    Forum Contributor
    Join Date
    09-09-2008
    Location
    Middlesbrough, England
    MS-Off Ver
    2007
    Posts
    174

    Worksheet_Change Looping (Why?)

    I have the following code and they copy and paste special keeps looping, is there any reason why?

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 03-14-2014, 12:47 PM #2
    Izandol
    Izandol is offline
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: Worksheet_Change Looping (Why?)

    You do change cells inside Change event, so event is raised again, and again, et cetera. 
    Please Login or Register  to view this content.
    • Please remember to mark threads Solved with Thread Tools link at top of page.
    • Please use code tags when posting code: [code]Place your code here[/code]
    • Please read Forum Rules
    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. Do Until Looping (not looping through all other columns)
    By orle8050 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-11-2013, 10:37 AM
  2. Need help creating VBA looping code in "Worksheet_Change(ByVal Target As Range)"
    By jimredfield in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-11-2012, 03:09 PM
  3. Excel 2007 : Worksheet_Change
    By ThomasHaller in forum Excel General
    Replies: 3
    Last Post: 12-19-2011, 11:58 AM
  4. Disable Worksheet_Change event while looping
    By thomasrawley in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-06-2006, 06:31 PM
  5. [SOLVED] Worksheet_Change
    By ram in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-05-2006, 07:15 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