View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Darin Kramer Darin Kramer is offline
external usenet poster
 
Posts: 397
Default Sheet Rename (day 2)

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 ***