Menu

copy paste values only using destination:=

Search this Thread

Prev

Previous Post

Next Post

Next

#4

Report Post

Posted to microsoft.public.excel.programming

Don Guillett Don Guillett is offline

Don Guillett is offline

external usenet poster

Posts: 10,124

Default

copy paste values only using destination:=

Glad to help.
For an entire range use
range("a1:a5").value=range("b1:b5").value

--
Don Guillett
SalesAid Software

"Spike" wrote in message
...
Obvious i suppose really!!!

Sorry brain totally out of gear. Many thanks.
--
with kind regards

Spike

"Don Guillett" wrote:

try
range("a1")=range("b2")

--
Don Guillett
SalesAid Software

"Spike" wrote in message
...
Is it possible to use the copy past destination one liner to paste
values
only?? If so i would be very grateful for the relevant code

Many thanks
--
with kind regards

Spike

Reply With Quote

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 and paste up to values in last row	Scott	Excel Discussion (Misc queries)	2	September 23rd 09 10:23 PM
Copy/Paste how to avoid the copy of formula cells w/o calc values	Dennis	Excel Discussion (Misc queries)	10	March 2nd 06 10:47 PM
copy destination values	Pete[_23_]	Excel Programming	1	March 22nd 05 04:40 PM
user form to copy and paste from source to destination	rbekka33	Excel Programming	2	September 13th 04 05:01 AM
How do i compare values from two sheet and copy & paste if values match?	rozb	Excel Programming	0	March 5th 04 12:06 AM

All times are GMT +1. The time now is 07:43 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement