Thread: Copy Range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Glen Mettler[_4_] Glen Mettler[_4_] is offline
external usenet poster
  
Posts: 70
Default Copy Range
I need to copy a range from one sheet to another and past values only.
This works but pastes formulas and all:
SourceRange.Copy DestRange

I need to paste values only but this doesn't work:
SourceRange.Copy DestRange.PasteSpecial(Paste:=xlPasteValues)

How do I do it?

Glen


Reply With QuoteReply With Quote