Copying with .Value - ExcelBanter

Posted to microsoft.public.excel.programming

Simon[_2_] Simon[_2_] is offline

external usenet poster

Posts: 89

Copying with .Value

Cells.Find("latest").Select
Selection.Copy Destination:=ActiveCell.Offset(0, 1)

I wish to use only the value of the cell.

What is wrong with

Cells.Find("latest").Select
Selection.Copy Destination:=ActiveCell.Offset(0, 1)

Thanks

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
Error Copying File or Folder message when copying file to CD	[email protected]	Excel Programming	0	August 2nd 08 05:43 PM
Copying sheets without copying named ranges	NMACK08	Excel Programming	1	February 5th 08 08:53 PM
Which is faster, copying range to another set of ranges or copying tomemory?	axwack	Excel Programming	2	December 12th 07 01:19 PM
copying the Hyperlink function result without copying the actual formula	mcheng	Excel Worksheet Functions	2	June 9th 07 02:43 AM
TextBox copying not like windows copying, heh?	Antoine	Excel Programming	3	August 16th 05 03:35 PM

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

Menu

About Us