+ Reply to Thread
Results 1 to 6 of 6

VBA stopped working

  1. 06-01-2015, 02:34 PM #1
    tsakta13ole
    tsakta13ole is offline
    Forum Contributor
    Join Date
    10-26-2013
    Location
    Athens, Greece
    MS-Off Ver
    Excel 2013
    Posts
    248

    VBA stopped working

    Hi. I'm attaching my workbook. Suddenly my macro stopped working. Actually it seems to be working but no data appear at sheet "P_L events up to 2 months". This is the code 

    Please Login or Register  to view this content.
    Thanks for any help!

    RSX NEW.xlsm
    Reply With QuoteRegister To Reply
  2. 06-01-2015, 02:49 PM #2
    AB33
    AB33 is offline
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: VBA stopped working

    Change the value in to row

    Please Login or Register  to view this content.
    Last edited by AB33; 06-01-2015 at 02:55 PM.
    Reply With QuoteRegister To Reply
  3. 06-01-2015, 02:53 PM #3
    JOHN H. DAVIS
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: VBA stopped working

    Works for me. I think you had so errant data way down on your spreadsheet so it pasting there around row 425.
    Reply With QuoteRegister To Reply
  4. 06-01-2015, 02:55 PM #4
    Norie
    Norie is offline
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,644

    Re: VBA stopped working

    Where should the data be going to on 'P_L events up to 2 months'?

    Have you checked to see if the data is going elsewhere in the sheet?
    If posting code please use code tags, see here.
    Reply With QuoteRegister To Reply
  5. 06-01-2015, 04:46 PM #5
    tsakta13ole
    tsakta13ole is offline
    Forum Contributor
    Join Date
    10-26-2013
    Location
    Athens, Greece
    MS-Off Ver
    Excel 2013
    Posts
    248

    Re: VBA stopped working

    Thanks! It was going to row 425.
    Reply With QuoteRegister To Reply
  6. 06-02-2015, 06:17 AM #6
    JOHN H. DAVIS
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: VBA stopped working

    You're welcome. Glad to help out and thanks for the feedback. Thanks for the rep.
    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. ocde working in one windows login but stopped working in another.
    By rama1209 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-02-2011, 08:38 AM
  2. Everything stopped working
    By vamedic11 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-30-2010, 11:20 PM
  3. VBA stopped working!!
    By maxthebear in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-18-2009, 09:51 PM
  4. It's stopped working
    By mikhailia in forum Excel Programming / VBA / Macros
    Replies: 32
    Last Post: 01-22-2007, 10:12 PM
  5. VB Stopped Working
    By mptkeenan@gmail.com in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-28-2005, 09:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1