Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a New Macro
OK, so I have this maco to name a tab to the contents of cell A1, but I have
no idea what to do with the macro... Sub name_um() For Each ws In Worksheets ws.Name = ws.Range("A1").Value Next End Sub ....and can I save the macro so that I can use it in other workbooks? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a New Macro
I think Ron de Bruin does a pretty good job of explaining it. (but I already know how to ride the bicycle <g - you will have to be the judge) Try here... http://www.rondebruin.nl/code.htm -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "SharonJo" wrote in message OK, so I have this maco to name a tab to the contents of cell A1, but I have no idea what to do with the macro... Sub name_um() For Each ws In Worksheets ws.Name = ws.Range("A1").Value Next End Sub ....and can I save the macro so that I can use it in other workbooks? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating Macro | Excel Discussion (Misc queries) | |||
Macro Creating | New Users to Excel | |||
Creating a macro | New Users to Excel | |||
Need Help Creating A Macro | Excel Worksheet Functions | |||
Creating a macro | Excel Worksheet Functions |