| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Whats wrong with this? MyWBAccRep.Sheets("Volumes").Cells.Find("latest"). Copy.Offset(0,
MyWBAccRep.Sheets("Volumes").Cells.Find("latest"). Copy
ActiveCell.Offset(0, 1).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False In fact the above doesn't work either |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Whats wrong with this? MyWBAccRep.Sheets("Volumes").Cells.Find("latest"). Copy.Offset(0, 1).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Modify this idea to suit
Sub findit() Columns(3).Find("latest").Offset(, 1).Value = _ Columns(3).Find("latest").Value End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "Simon" wrote in message ... 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| find "Cancellation" in column "A" and copy all data from Columns B-F onto another Sheet | Excel Programming | |||
| Application.Goto Reference:="ActiveCell.Value"??? Whats wrong?? | Excel Programming | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Can you "duplicate" "copy" listboxes and code to multiple cells? | Excel Programming | |||
![Simon[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
