View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
Mattlynn via OfficeKB.com Mattlynn via OfficeKB.com is offline
external usenet poster
 
Posts: 140
Default Please add a "Paste Value" Command to this macro.

Thanks everyone for your help.
I have now got a great macro, that does just the trick
May thNka
Matt




JLGWhiz wrote:
Hi Ron, Senility is setting in again. I forgot that if before or after is
not specified that it automatically creates a new workbook. I have to use
references more and more these days. :(

Hi Original code is here (Example 2)
http://www.rondebruin.nl/mail/folder1/mail2.htm

[quoted text clipped - 100 lines]
End With
End Sub


--
Matt Lynn

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