LinkBack URL
About LinkBacks
Hi,
Assuming I would like to create 12 sheets (months of the year).
How would i look over a function to create those sheets in the most concise way possible.
Thank you
Hi,
Assuming I would like to create 12 sheets (months of the year).
How would i look over a function to create those sheets in the most concise way possible.
Thank you
Please Login or Register to view this content.
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by mehmetcik; 10-11-2018 at 01:29 PM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Does not work. Run-time error '1004':Originally Posted by mehmetcik
That name is already taken. try a different none.
Shouldnt i create an array first like:
Tabs = ("JANUARY", "FEBRUARY", ...,"X")
and then a for loop through tabs ?
This is based on US date format. For European format change to Format("1/" & i & "/2018", "mmmm")Please Login or Register to view this content.
Last edited by JLGWhiz; 10-11-2018 at 01:13 PM.
Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
Just when I think I am smart, I learn something new!
Try These Instead
Please Login or Register to view this content.
Please Login or Register to view this content.
Please Login or Register to view this content.
Another optionPlease Login or Register to view this content.
can you please explain the i*29 as an expression and the need to write 'i' after next?Another optionPlease Login or Register to view this content.
thank you sir
You don't need to put the i after Next, I just prefer it. Especially if you have nested loops as it shows clearly which loop you are referring to.
The i*29 simply gives you a number, which is effectively converted to a date & then formatted to give the month.
So when i is 1 i*29 is 29 which becomes 29 jan 1900
If i=2 the date is 27 Feb 1900 etc.
Thanks for the rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks