Used Range copy Paste Values | MrExcel Message Board

link管理

链接快照平台

输入网页链接，自动生成快照
标签化管理网页链接

相关文章推荐

非常酷的双杠 · Maven Central: ...· 2 天前 ·

失眠的围巾 · 学会配置 Fontconfig，让 ...· 3 周前 ·

怕老婆的沙发 · ORA-29250 to ORA-32799· 4 月前 ·

发怒的芒果 · 一个SSL证书只能对应一个端口吗？_SSL证书· 4 月前 ·

飞翔的酸菜鱼 · Android网络库大比拼：OkHTTP、R ...· 5 月前 ·

JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.

'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,

With UPDT.Sheets("View1").UsedRange
   Tool.Sheets("View1Pivot").Cells(1, 1).Resize(.Rows.Count, .Columns.Count).Value = .Value
End With

Re your reported post, we don't mark threads solved here - this isn't ExcelForum. (it's working for a start.

)

Thanks Rory,
Would the resizing type routine run faster than the copy/paste routine? It seems like it would, because it bypasses the clipboard. I'm stringing a lot of operations together, so the faster routines are very much appreciated.
Thanks for letting me know about not marking the posts 'Solved'. I'll try to remember that next time I'm here.
Thanks,