hi guys!
i am trying to create workbook in which i will collect data on daily biases. Therefore, ever month i need to change/create sheet names according to the selected month (month selection is in sheet no 12) dates. Now i need a VBA code which automatically create/change sheets name.
Note: i have data in from sheet 1 to sheet 12. VBA should create/change sheet after sheet No. 12.
try such code and adopt it to your needs:
Please Login or Register to view this content.
Best Regards,
Kaper
actually i need sheets name as selected months date. if a month have 31 days automatically 31 sheets created with date names.
and month will be selected from sheet:1 Row:2 & Column:C
Try such code - not tested, because you attached no file.Please Login or Register to view this content.
Notes:
- if by sheet:1 you not ment first sheet but sheet where tab with sheetname change bot sheets(1) to sheets("1")
- cell c2 in sheet 1 shall have month number in it otherwise sheets(1).cells(2,"C") will mot be valid - change procedure accordingly
I have attached sample file in which i would like to change month in sheet:1 row:2 column:C than VBA/MACRO will auto create sheets according numbers of days of selected month and name those sheets as 1, 2, 3. and remove sheet no 31 if month have 30 days
If you want the process to happen every time you chanche C2 then add the code:
to your sheet1 code (it's already ther in the attachment. If yo do not want such action - delete it)Please Login or Register to view this content.
and main code in standard module:
If you delete first code, you will have to run this as any other macro: Alt+F8 select name and RunPlease Login or Register to view this content.
when i paste those code in my file below mentioned error
Untitled.jpg
after playing with codes finally i solved it. Thank you Kaper.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks