Posted to microsoft.public.excel.programming

Tom Joseph Tom Joseph is offline

external usenet poster

Posts: 51

How to copy range and paste as values

Worksheets("Outliers_1").Cells.Copy Worksheets("Outliers").Range("A1")

Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Lookin cell values, copy a range and paste it	[email protected]	Excel Programming	9	October 30th 08 03:15 PM
Copy range in macro using paste special values	Jeff	Excel Discussion (Misc queries)	2	August 20th 07 08:12 PM
copy and paste values in a range	Dave Peterson	Excel Programming	4	December 14th 06 10:17 PM
copy and paste values in a range	keri	Excel Programming	0	December 14th 06 06:45 PM
copy / paste values for certain range	Eric Dreshfield	Excel Programming	2	September 10th 03 04:04 PM

All times are GMT +1. The time now is 06:37 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us