Thread: auto name sheet w/ macro or function
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
laneman[_3_] laneman[_3_] is offline
external usenet poster
  
Posts: 1
Default auto name sheet w/ macro or function
Bob, it works now, but after the macro runs I get a Runtime error '1004
Appliction defined orobject defined error. When I checked the debugge
the line [sh.Name = sh.Range("H3").Value] is highlighted. Any way t
get rid of this pop-up

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

Reply With QuoteReply With Quote