+ Reply to Thread
Results 1 to 6 of 6

VBA stopped working again

  1. #1
    Forum Contributor
    Join Date
    10-26-2013
    Location
    Athens, Greece
    MS-Off Ver
    Excel 2013
    Posts
    248

    VBA stopped working again

    Hi. I'm attaching my workbook. Suddenly this macro stopped working:
    Please Login or Register  to view this content.
    RSX quest.xlsm
    I did not change anything.
    Thanks for any help!

  2. #2
    Forum Contributor
    Join Date
    09-16-2009
    Location
    Dallas, TX
    MS-Off Ver
    Office 2013
    Posts
    107

    Re: VBA stopped working again

    What is it intended to do? Does it produce an error or does nothing happen? What line produces the error or does not function as expected when you step through the code?

  3. #3
    Valued Forum Contributor bulina2k's Avatar
    Join Date
    11-20-2012
    Location
    Urziceni, Ialomita, Romania
    MS-Off Ver
    2019 and 365
    Posts
    861

    Re: VBA stopped working again

    Hello there,

    the line
    Please Login or Register  to view this content.
    should find last used cell in column T, but that column is empty. So the FOR loop
    Please Login or Register  to view this content.
    will be skipped.
    Why are the statements in FOR loop written two times each?
    .. and don't forget to have fun!
    Bogdan.

    mark SOLVED and Add Reputation if my answer pleases you

  4. #4
    Forum Contributor
    Join Date
    10-26-2013
    Location
    Athens, Greece
    MS-Off Ver
    Excel 2013
    Posts
    248

    Re: VBA stopped working again

    Thank you for your answers. I just solved the problem. I had changed the columns in Sheets("events exp up to 2 months"). Sorry for that. What it does is at sheet "P_L events up to 2 months" it copy pastes duplicate at columns B, C and D columns R,S and T from sheet ("events exp up to 2 months").

  5. #5
    Valued Forum Contributor bulina2k's Avatar
    Join Date
    11-20-2012
    Location
    Urziceni, Ialomita, Romania
    MS-Off Ver
    2019 and 365
    Posts
    861

    Re: VBA stopped working again

    Yes I understand but why twice? Aren't these two lines identical ?
    Please Login or Register  to view this content.

  6. #6
    Forum Contributor
    Join Date
    10-26-2013
    Location
    Athens, Greece
    MS-Off Ver
    Excel 2013
    Posts
    248

    Re: VBA stopped working again

    I want them twice because I'm simulating P/L for some stock options. So I buy some options and when I sell I want some columns to be the same.

+ 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. 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. VBA stopped working!!
    By maxthebear in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-18-2009, 09:51 PM
  3. VBA Stopped Working!
    By SamuelT in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-16-2007, 11:12 AM
  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 [email protected] 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1