Thread: How do i copy a active sheet to a new sheet with code and everything
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Karill[_2_] Karill[_2_] is offline
external usenet poster
  
Posts: 1
Default How do i copy a active sheet to a new sheet with code and everything

Many thanks for the quick reply! I did make an test with the code but
do rescive an error when i run it.
Run-time error '438'
Object doesn't support this property or method

On this row

For Each Sh In bk


Best regards
Karil

--
Karil
-----------------------------------------------------------------------
Karill's Profile: http://www.excelforum.com/member.php...fo&userid=3335
View this thread: http://www.excelforum.com/showthread.php?threadid=53188

Reply With QuoteReply With Quote