| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Method 'Paste' of object '_worksheet' failed
Run time error '-2147417848 (80010108)
I am copying a range from one spreadsheet and pasting to another. Anybody else seen this? Greg |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Method 'Paste' of object '_worksheet' failed
Hi Greg
Post your code in this thread -- Regards Ron de Bruin http://www.rondebruin.nl "Greg Bloom" wrote in message news:loRcd.270696$D%.249449@attbi_s51... Run time error '-2147417848 (80010108) I am copying a range from one spreadsheet and pasting to another. Anybody else seen this? Greg |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Method 'Paste' of object '_worksheet' failed
On Error GoTo TemplateErrorRetailPrice '10/18/2004
Range("d" + Trim$(Str(zTopRow))).Activate Workbooks(OE_Data).Sheets(zWorksheet).Range("l2:l2 500").Copy '10/05/04 ActiveSheet.Paste *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Method 'Paste' of object '_worksheet' failed
Do you run the code from a button in excel 97 ??
-- Regards Ron de Bruin http://www.rondebruin.nl "Greg Bloom" wrote in message ... On Error GoTo TemplateErrorRetailPrice '10/18/2004 Range("d" + Trim$(Str(zTopRow))).Activate Workbooks(OE_Data).Sheets(zWorksheet).Range("l2:l2 500").Copy '10/05/04 ActiveSheet.Paste *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Method 'Paste' of object '_worksheet' failed
On Error GoTo TemplateErrorRetailPrice '10/18/2004
Range("d" + Trim$(Str(zTopRow))).Activate Workbooks(OE_Data).Sheets(zWorksheet).Range("l2:l2 500").Copy '10/05/04 ActiveSheet.Paste *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Paste Method of Worksheet Failed When Copying Chart Object | Excel Discussion (Misc queries) | |||
| Method 'MailEnvelope' of object '_Worksheet' failed | Excel Discussion (Misc queries) | |||
| Method 'Paste' of object '_Worksheet' failed | Excel Discussion (Misc queries) | |||
| METHOD "SELECT" OF OBJECT '_WORKSHEET' FAILED when opening a file | Excel Programming | |||
| HELP!!!! -- (Method Range of _Worksheet failed) ERROR! | Excel Programming | |||
Hybrid Mode
