Thread: Whats wrong with this? MyWBAccRep.Sheets("Volumes").Cells.Find("latest").Copy.Offset(0,
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Simon[_2_] Simon[_2_] is offline
external usenet poster
  
Posts: 89
Default 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 QuoteReply With Quote