Hi. I attached my workbook. In spreadsheet P_L events up to 2 months I use the following macro which I have use it before and it worked:
It says runtime error 9 and subscript out of range.
Please Login or Register to view this content.
Any help?
Thanks!
RSX DATA question f.xlsm
Last edited by tsakta13ole; 05-21-2015 at 11:45 AM.
Hi tsakta,
Please edit your post, highlight the code, and press the "#" button in the menu to put code tags around it. Then we can look at helping you further.
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
The problem is that (probably by accident) a space was added to the sheet name "P_L events up to 2 months". Double click the sheet's tab, and remove the space at the end, it is "P_L events up to 2 months " right now.
I was extra careful when I edited the module for spaces but did not predict that. Thanks!
You're welcomeand thanks for marking as solved, and for the rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks