Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pasting values from a closed Excel instance
I copy a cell containing a date from a sheet of one instance of Excel. Then
closes Excel down. In another instance of Excel I like to PasteSpecial the value of the cell. The pasting part is what I like to do using VBA. But if I record a macro it comes up with ActiveSheet.PasteSpecial Format:="Text"... So its the text value of the date thats pasted, not the numeric value. If I try using Selection.PasteSpecial Paste:=xlPasteValues I get a runtime error 1004: The method PasteSpecial of class Range failed. (My own translation from a danish version of Excel, so it may bw incorrect, but I hope you get the idea. How should I accomplish what I need? Jan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Pasting Values and not Formula | Excel Discussion (Misc queries) | |||
Excel is pasting values, not formulas by default | Excel Discussion (Misc queries) | |||
Return Single Instance of Numeric Values from a Column | Excel Worksheet Functions | |||
How can I add values to a closed excel file? | Excel Worksheet Functions | |||
Excel clipboard should allow pasting of formulae not just values | Excel Discussion (Misc queries) |