web 2.0


Change name of a worksheet according to a cell value

Author: Robert Martim | Posted: 27. January 2009 09:00 0
This short code shows you how to change a worksheet name in Excel by attaching its name to a cell...


 


Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Me.Name = Range("A1").Text
End Sub
 

Tags: , ,

Microsoft Excel | Microsoft Excel - VBA

E-mail | Kick it! | DZone it! | del.icio.us
Permalink | Comments (0) | Post RSSRSS comment feed
Comments are closed