Hi. I'm attaching my workbook. Suddenly this macro stopped working:
RSX quest.xlsmPlease Login or Register to view this content.
I did not change anything.
Thanks for any help!
Hi. I'm attaching my workbook. Suddenly this macro stopped working:
RSX quest.xlsmPlease Login or Register to view this content.
I did not change anything.
Thanks for any help!
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?
Hello there,
the lineshould find last used cell in column T, but that column is empty. So the FOR loopPlease Login or Register to view this content.
will be skipped.Please Login or Register to view this content.
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
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").
Yes I understand but why twice? Aren't these two lines identical ?
Please Login or Register to view this content.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks