Thread: error with macro to name new worksheet with cell from old worksheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Snake Plissken[_2_] Snake Plissken[_2_] is offline
external usenet poster
  
Posts: 75
Default error with macro to name new worksheet with cell from old worksheet
before line:

Newsh.Name = sh.Range("A2").Value (ERROR HERE)


put this :
msgbox (sh.Range("A2").Value)
exit sub

then try to look at the msgbox content - maybe it will give u any idea

Reply With QuoteReply With Quote