Thread: Rename active sheet to contents of specific cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
burl_rfc burl_rfc is offline
external usenet poster
  
Posts: 24
Default Rename active sheet to contents of specific cell
I fixed it.......

By changing the following:-

ActiveSheet.Name = Range("b6")
to
sh.name = Range("b6")

Thanks
Burl

Reply With QuoteReply With Quote