Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheet Tabs
Hi All
When I run the following macro everything works OK with no problems Sub Macro7() 'Copies and Saves Result At the End Of Workbook Application.ScreenUpdating = False Sheets("Result").Select Sheets("Result").Copy After:=Sheets(29) ActiveWindow.ScrollWorkbookTabs Position:=xlFirst Sheets("Result").Select Range("A2:J2").Select Selection.ClearContents Range("A3:J3").Select Selection.ClearContents Range("B5:J24").Select Selection.ClearContents Range("A2:J2").Select Application.ScreenUpdating = True End Sub Is it possible to enter Text in Cell "L4" for example London and when the Result Sheet is copied and moved using the Macro above - the Sheet Tab changes to the text in "L4" -- Many thanks hazel |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheet Tabs
Just add
Activesheet.Name = Range("L4").Value -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Hazel" wrote in message ... Hi All When I run the following macro everything works OK with no problems Sub Macro7() 'Copies and Saves Result At the End Of Workbook Application.ScreenUpdating = False Sheets("Result").Select Sheets("Result").Copy After:=Sheets(29) ActiveWindow.ScrollWorkbookTabs Position:=xlFirst Sheets("Result").Select Range("A2:J2").Select Selection.ClearContents Range("A3:J3").Select Selection.ClearContents Range("B5:J24").Select Selection.ClearContents Range("A2:J2").Select Application.ScreenUpdating = True End Sub Is it possible to enter Text in Cell "L4" for example London and when the Result Sheet is copied and moved using the Macro above - the Sheet Tab changes to the text in "L4" -- Many thanks hazel |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheet Tabs
Hi Bob
Thanks been messing about for weeks re - typing Sheet Tab names 40 a week I won't have to do from now on --- Thanks -- Many thanks hazel "Bob Phillips" wrote: Just add Activesheet.Name = Range("L4").Value -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Hazel" wrote in message ... Hi All When I run the following macro everything works OK with no problems Sub Macro7() 'Copies and Saves Result At the End Of Workbook Application.ScreenUpdating = False Sheets("Result").Select Sheets("Result").Copy After:=Sheets(29) ActiveWindow.ScrollWorkbookTabs Position:=xlFirst Sheets("Result").Select Range("A2:J2").Select Selection.ClearContents Range("A3:J3").Select Selection.ClearContents Range("B5:J24").Select Selection.ClearContents Range("A2:J2").Select Application.ScreenUpdating = True End Sub Is it possible to enter Text in Cell "L4" for example London and when the Result Sheet is copied and moved using the Macro above - the Sheet Tab changes to the text in "L4" -- Many thanks hazel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sheet tabs is checked but I can't see my tabs | Excel Discussion (Misc queries) | |||
tabs are missing even though 'tools-options-view-sheet tabs' ok? | Excel Worksheet Functions | |||
How do I change the Excel sheet tab bar to display more sheet tabs | Excel Discussion (Misc queries) | |||
I want to print out the sheet tabs (sheet names) | Excel Worksheet Functions | |||
hide sheet? uncheck sheet tabs? or ??? | Excel Programming |