Whats wrong with this? MyWBAccRep.Sheets("Volumes").Cells.Find("latest"). Copy.Offset(0,

Posted to microsoft.public.excel.programming

Simon[_2_] Simon[_2_] is offline

external usenet poster

Posts: 89

Whats wrong with this? MyWBAccRep.Sheets("Volumes").Cells.Find("latest"). Copy.Offset(0,

MyWBAccRep.Sheets("Volumes").Cells.Find("latest"). Copy.Offset(0,
1).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks:=False, Transpose:=False

Thanks (I've put it all on one line).

It works as

MyWBAccRep.Sheets("Volumes").Cells.Find("latest"). Copy

ActiveCell.Offset(0, 1).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
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell	Steve Kay	Excel Discussion (Misc queries)	2	August 8th 08 01:54 AM
find "Cancellation" in column "A" and copy all data from Columns B-F onto another Sheet	bjohnson	Excel Programming	1	September 20th 07 04:02 PM
Application.Goto Reference:="ActiveCell.Value"??? Whats wrong??	[email protected]	Excel Programming	13	July 12th 06 11:47 AM
HELP on "left","right","find","len","substitute" functions	serene83	Excel Discussion (Misc queries)	5	June 27th 06 02:23 AM
Can you "duplicate" "copy" listboxes and code to multiple cells?	HotRod	Excel Programming	1	September 1st 04 05:03 PM

All times are GMT +1. The time now is 10:31 AM.

Menu

About Us