| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to use Object.Copy(Destination) method PasteSpecial(xlPasteVal
Hello, Folks
The following line in VB works fine, but it pastes the borders, etc... assigned to the named EntryDate cell. Is there a way to ammend this line to PasteSpecial (xlPasteValues) ? Range("EntryDate").Copy shComments.Cells(iNextEmptyDateCell, "C") Thanks, Randy |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to use Object.Copy(Destination) method PasteSpecial(xlPasteVal
Hi Randy,
Try: Range("EntryDate").Copy shComments.Cells(iNextEmptyDateCell, "C"). _ PasteSpecial Paste:=xlValues Application.CutCopyMode = False --- Regards, Norman "RAP" wrote in message ... Hello, Folks The following line in VB works fine, but it pastes the borders, etc... assigned to the named EntryDate cell. Is there a way to ammend this line to PasteSpecial (xlPasteValues) ? Range("EntryDate").Copy shComments.Cells(iNextEmptyDateCell, "C") Thanks, Randy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Any method to copy the hyperlink address from an Office Object? | Excel Discussion (Misc queries) | |||
| PasteSpecial Method Error | Excel Discussion (Misc queries) | |||
| Using a PasteSpecial within a Destination:= line | Excel Worksheet Functions | |||
| .Copy Destination:= .PasteSpecial ??? | Excel Programming | |||
| Making VB PasteSpecial method to work the same as Excels Application | Excel Programming | |||
Hybrid Mode
