It should work, but could be better to change Range("B2") to Range("B2").Value.

Is there a sheet called "Master". If not, then this will cause problems.

Also, is Range("B2") empty? If it is then there is no way this can work as a
sheet always has to be cleed something

"Darin Kramer" wrote:

Guys...

Whats wrong with this vb...

Sub renmame_sheet()
Sheets("Master").Select
ActiveSheet.Name = Range("b2")
End Sub

I get a run time 1004 "application defined or object defined" error...??

*** Sent via Developersdex http://www.developersdex.com ***