1- How to make vba create new work book and save selected in it, on a variable bases, which means for every new change a new workbook?
2- Can I know whats wrong with the following range not executing on the attached spreadsheet;
Untitled.png
Please Login or Register to view this content.
Last edited by jeffreybrown; 07-27-2013 at 11:54 AM. Reason: As per Forum Rule #3, please use code tags…Thanks.
No spreadsheet attached.
If posting code please use code tags, see here.
Hello
When deleting rows, you should start from the bottom and work up. I have changed your code to do so.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Dear Norie,
Thank you for your interest to help.
attached is excel file with its vba coding for your attention.
the problem faced is when arriving at calling the remove zero returns sub as explained before.
In general, whats required is to sort data and clean it to be pasted on another platform that conducts the event study with conditions prementioned
in the main sub.
One important matter please, how can i create new work book based on variables, thats to say, every time the i in my sub changes and arrives to the end to copy the range and paste it in a new workbook (i variable based).
Hope I was clear but not complicated.
Thank You
still facing same problem, see attached
what about creating work sheets and named based on a variable change.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks