I have an excel file with many worksheet in this file. I have a "totals" worksheet which varies in location depending on who last viewed/used the file. What i want to do is add a new worksheet (called latest_month) so that this new worksheet is just prior to the "totals" worksheet. Does anyone know how to do this?
I found this code to add a worksheet just prior to the last worksheet in the file.....but i have not been able to modify it to work for my situation.
Please Login or Register to view this content.
Bookmarks