Thread: vba pastespecial
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
ben.c ben.c is offline
external usenet poster
  
Posts: 32
Default vba pastespecial
hi
the pastespecial is not good in your exemple..
To have the value paste special, use PasteSpecial Paste:=xlValue
It should work..
But you can have found this just by record a value paste special on your sheet

Reply With QuoteReply With Quote