Used Range copy Paste Values

[jomili]

I'm trying to do something that should be fairly simple, but I'm having trouble. What I want is to copy the Used Range from my View1 sheet and paste only the values into my View1Pivot sheet. Here's the code I'm trying to use:

'Copy the View1 Information
    UPDT.Sheets("View1").UsedRange.Value.Copy Destination:=Tool.Sheets("View1Pivot").Cells(1, 1)

If I take out "Value" then the code works just fine at copying and pasting, but how do I change it to only give me the values?
Thanks,
John

 

[jomili]

Value2?

 

[RoryA]

instead of .Value use .Value2

 

[jomili]

Like this?

[COLOR=black][FONT=Courier New]With UPDT.Sheets("View1").UsedRange<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>[/FONT][/COLOR]
[COLOR=black][FONT=Courier New] Tool.Sheets("View1Pivot").Cells(1, 1).Resize(.Rows.Count, .Columns.Count).Value2 = .Value2[/FONT][/COLOR]
[COLOR=black][FONT=Courier New][COLOR=black][FONT=Courier New]End With[/FONT][/COLOR]<o:p></o:p>[/FONT][/COLOR]

 

[RoryA]

Yep.