| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I paste from clipboard to range using Excel VBA
I have just moved from Windows 2000 & Office 2002 (Old) to XP Pro and Office
2003 (New). The following statements work in the old version and also in the new version when I step through the code using the debugger. They fail when I try and run the macro in the new version. Code: Dim oSheet As Worksheet ' copy text to windows clipboard oSheet.Paste ' error generated on the above stating "Paste method of Worksheet Class failed." |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cannot paste between 2 excel spreadsheets w/o office clipboard ope | Excel Discussion (Misc queries) | |||
| Unable to copy/paste in Excel once clipboard gets full | Excel Discussion (Misc queries) | |||
| how do I paste formulas in excel clipboard? | Excel Discussion (Misc queries) | |||
| clipboard in Excel collects but will only paste most recent item | Excel Discussion (Misc queries) | |||
| Paste Clipboard from Word to last row in excel | Excel Programming | |||
Threaded Mode
