Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Putting the date as a sheet name
Hi I've created some macros that create different sheets within a file. However, i'd like each sheet to display the date along with a pre defined name. Is it possible to incorporate this into the macro.....if so, how would i do it? Thanks Matt -- matthewwookie ------------------------------------------------------------------------ matthewwookie's Profile: http://www.excelforum.com/member.php...o&userid=27503 View this thread: http://www.excelforum.com/showthread...hreadid=470722 |
#2
|
|||
|
|||
Hello Matt
You don't say how you have created your sheets, so provided all sheets have to be renamed in your workbook, you could use something like this: Dim wsh As Worksheet For Each wsh In ThisWorkbook.Worksheets wsh.Name = wsh.Name & "_" & Format(Date, "mmddyy") Next wsh HTH Cordially Pascal "matthewwookie" a écrit dans le message de news: ... Hi I've created some macros that create different sheets within a file. However, i'd like each sheet to display the date along with a pre defined name. Is it possible to incorporate this into the macro.....if so, how would i do it? Thanks Matt -- matthewwookie ------------------------------------------------------------------------ matthewwookie's Profile: http://www.excelforum.com/member.php...o&userid=27503 View this thread: http://www.excelforum.com/showthread...hreadid=470722 |
#3
|
|||
|
|||
Hi Thanks for that, the sheets are produced by a macro and its only the ones that are produced that way need to be renamed. all original sheets in the book should stay as they are. Any ideas? Matt -- matthewwookie ------------------------------------------------------------------------ matthewwookie's Profile: http://www.excelforum.com/member.php...o&userid=27503 View this thread: http://www.excelforum.com/showthread...hreadid=470722 |
#4
|
|||
|
|||
Matt
As I said it depends on how your macro creates the worksheets. If your macro uses a "For Next" loop then you can use as a start the sample code I supplied. But I suggest you post the macro here so that we can help you further. Cordially Pascal "matthewwookie" a écrit dans le message de news: ... Hi Thanks for that, the sheets are produced by a macro and its only the ones that are produced that way need to be renamed. all original sheets in the book should stay as they are. Any ideas? Matt -- matthewwookie ------------------------------------------------------------------------ matthewwookie's Profile: http://www.excelforum.com/member.php...o&userid=27503 View this thread: http://www.excelforum.com/showthread...hreadid=470722 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Value between 2 dates | Excel Worksheet Functions | |||
Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
how to use lookup a value by date for criteria in Excel sheet | Excel Worksheet Functions |