Posted to microsoft.public.excel.programming

external usenet poster

Posts: 27

PasteSpecial value

Here are two example of Code. Trying to copy Range of cells from SourceWS to
TargetWS.

This code working fine, as I have formula at Source its copy Formul.
vSourceWS.Range("N" & vSourceLastRow).CurrentRegion.Copy vTargetWS.Range("F"
& vTargetLastRow)

I tried to use PasteSpecial in result receiving Syntex Error
vSourceWS.Range("N" & vSourceLastRow).CurrentRegion.Copy _
vTargetWS.Range("F" & vTargetLastRow).PasteSpecial Paste:=xlPasteValues

Whats worng!

Regards
Atif

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
Why need to use Selection.PasteSpecial vs myRange.PasteSpecial	[email protected]	Excel Programming	4	June 25th 07 05:34 PM
Help with PasteSpecial	[email protected]	Excel Programming	2	June 9th 06 11:35 AM
PasteSpecial	Kevin	Excel Programming	3	October 7th 04 01:07 PM
pastespecial	Jeff	Excel Programming	4	September 28th 04 10:30 PM
pastespecial	billQ	Excel Programming	2	July 29th 03 11:39 PM

All times are GMT +1. The time now is 08:59 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us