| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to use VBA to name sheet ?
I have a file that i do not know how many sheet are there in before i need to copy contain of C4 to name of sheets Thank for your help. -- vumian ------------------------------------------------------------------------ vumian's Profile: http://www.excelforum.com/member.php...o&userid=36494 View this thread: http://www.excelforum.com/showthread...hreadid=564347 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How to use VBA to name sheet ?
For Each sh In Activeworkbook.Worksheets sh.Name = sh.Range("C4").Value Next sh -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "vumian" wrote in message ... I have a file that i do not know how many sheet are there in before i need to copy contain of C4 to name of sheets Thank for your help. -- vumian ------------------------------------------------------------------------ vumian's Profile: http://www.excelforum.com/member.php...o&userid=36494 View this thread: http://www.excelforum.com/showthread...hreadid=564347 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How to use VBA to name sheet ?
hi, sorry, i fail to understand your mean Could you be more specific,pls Thank you. -- vumian ------------------------------------------------------------------------ vumian's Profile: http://www.excelforum.com/member.php...o&userid=36494 View this thread: http://www.excelforum.com/showthread...hreadid=564347 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How to use VBA to name sheet ?
Create and run that macro.
Will do the job. Unless you left something out of the original query. Steve On Tue, 25 Jul 2006 16:02:59 +0100, vumian wrote: hi, sorry, i fail to understand your mean Could you be more specific,pls Thank you. |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How to use VBA to name sheet ?
thanks your idea, but here can not create macro coz i do not know how many sheet before ? How to use For statement here ? VBA only. thanks for your help. -- vumian ------------------------------------------------------------------------ vumian's Profile: http://www.excelforum.com/member.php...o&userid=36494 View this thread: http://www.excelforum.com/showthread...hreadid=564347 |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How to use VBA to name sheet ?
Why VBA only,
Anyway I count Excel macros as VBA "For Each sh In Activeworkbook.Worksheets" That does the counting for you. On Tue, 25 Jul 2006 16:19:26 +0100, vumian wrote: thanks your idea, but here can not create macro coz i do not know how many sheet before ? How to use For statement here ? VBA only. thanks for your help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum up columns in different sheet with error check | Excel Discussion (Misc queries) | |||
| Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
| lock tab in sheet 2 until cell in sheet one is completed | Excel Worksheet Functions | |||
| Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
| linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) | |||
Hybrid Mode
