Thread: Copy/Paste_Value problem.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Fan924 Fan924 is offline
external usenet poster
  
Posts: 238
Default Copy/Paste_Value problem.
Sheets("Sheet1").Select
Range("C1").Select
Selection.Copy
Sheets("Sheet2").Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone,
SkipBlanks:= _
False, Transpose:=False
Reply With QuoteReply With Quote