Thread: Copying a sheet to a certain position
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nicke[_6_] Nicke[_6_] is offline
external usenet poster
  
Posts: 1
Default Copying a sheet to a certain position

Is this what you are after?

Dim Before As String

Before = ActiveSheet.Range("O5")

ActiveSheet.copy Befo=Workbooks("Feedback Master Sheet.xls"). _
Sheets(Before

--
Nick
-----------------------------------------------------------------------
Nicke's Profile: http://www.excelforum.com/member.php...nfo&userid=293
View this thread: http://www.excelforum.com/showthread.php?threadid=26951

Reply With QuoteReply With Quote