Posted to microsoft.public.excel.programming

external usenet poster

Posts: 972

Ron de Bruin - Using PasteSpecial (xlPasteValues) instead of Copy

Ron,
Sorry to bother you, but I need to change the following line in the macro
you sent me:

..Offset(1, 0).Resize(.Rows.Count - 1, .Columns.Count).Copy DestSh.Cells(Last
+ 1, "A")

from a Copy operation to a PasteSpecial (xlPasteValues) operation. Could
you kindly tell me how to change it? Thanks for your help.
Regards, Bob

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
Copy a Range from each workbook - Ron de Bruin VBA - a problem	Philip[_2_]	Excel Worksheet Functions	5	March 11th 07 06:07 AM
Check if clipboard is empty before .PasteSpecial xlPasteValues	Spaan	Excel Programming	2	August 23rd 04 03:13 PM
Copy PasteSpecial	Rob van Gelder[_4_]	Excel Programming	1	July 28th 04 07:59 AM
ActiveCell.PasteSpecial (xlPasteValues) hangs program	hals_left	Excel Programming	3	June 9th 04 11:18 AM
Copy & PasteSpecial	Arthur[_3_]	Excel Programming	1	November 3rd 03 06:41 PM

All times are GMT +1. The time now is 11:28 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us