Thread: Trouble with copy to newly created sheet
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
brownti via OfficeKB.com brownti via OfficeKB.com is offline
external usenet poster
  
Posts: 103
Default Trouble with copy to newly created sheet
how would i incorporate this into my code?

merjet wrote:
I tried that but problem with it is the copied cells will be on
a sheet that i dont know the name of

You can find the name of the sheet with Selection.Worksheet.Name or
Selection.Parent.Name.

Hth,
Merejt

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200705/1

Reply With QuoteReply With Quote