macro which changes the name of tab in an excel sheet
 

need a macro which can change the name of the tab in a excel spreadsheet
according to the requirements

like if B4 cell comtains "vikram" then the name of this tab in this
excel sheet changes to vikram


ur help is highly appreciated

thank u so much


---
Message posted from http://www.ExcelForum.com/

macro which changes the name of tab in an excel sheet
 

activesheet.name=range("b4")
or
if lcase(range("b4"))="vikram" then activesheet.name=range("b4")

--
Don Guillett
SalesAid Software

"vikram " wrote in message
...
need a macro which can change the name of the tab in a excel spreadsheet
according to the requirements

like if B4 cell comtains "vikram" then the name of this tab in this
excel sheet changes to vikram


ur help is highly appreciated

thank u so much


---
Message posted from http://www.ExcelForum.com/

macro which changes the name of tab in an excel sheet
 

ActiveSheet.Name = Cells(4, 2).Value - Piku

--
Message posted from http://www.ExcelForum.com