|
Excel 97 compatibility
I have the the following error in Excel 97 (below) when running a macro
created in Version 2002. The code line is Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _ xlNone, SkipBlanks:=False, Transpose:=False Error Runtime error 1004 PasteSpecial method of range class failed Can you help on this and tell me what needs to be changed in the line of code above. The code is doing a past special of values and number formats ony Cheers Chris |
Have a look at a manual copy/paste in xl97 and you will see that this is not
an option in xl97. So, try pasting values and then pasting formats. ..PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=False ..PasteSpecial Paste:=xlFormats, Operation:=xlNone, SkipBlanks:= _ -- Don Guillett SalesAid Software "Chris" wrote in message ... I have the the following error in Excel 97 (below) when running a macro created in Version 2002. The code line is Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _ xlNone, SkipBlanks:=False, Transpose:=False Error Runtime error 1004 PasteSpecial method of range class failed Can you help on this and tell me what needs to be changed in the line of code above. The code is doing a past special of values and number formats ony Cheers Chris |
Thanks I'll try this, don't have a manual hence my problem
Chris "Don Guillett" wrote: Have a look at a manual copy/paste in xl97 and you will see that this is not an option in xl97. So, try pasting values and then pasting formats. ..PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=False ..PasteSpecial Paste:=xlFormats, Operation:=xlNone, SkipBlanks:= _ -- Don Guillett SalesAid Software "Chris" wrote in message ... I have the the following error in Excel 97 (below) when running a macro created in Version 2002. The code line is Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _ xlNone, SkipBlanks:=False, Transpose:=False Error Runtime error 1004 PasteSpecial method of range class failed Can you help on this and tell me what needs to be changed in the line of code above. The code is doing a past special of values and number formats ony Cheers Chris |
Oops
What I'll do is record a macro in 97 and then paste into my macro. This should do the trick Cheers Chris "Don Guillett" wrote: I didn't say manual. I said manual. So, I guess it depends on what your definition of is is.... I didn't mean to read a manual. I meant to do it manually. The dialog box will not show that option. -- Don Guillett SalesAid Software "Chris" wrote in message ... Thanks I'll try this, don't have a manual hence my problem Chris "Don Guillett" wrote: Have a look at a manual copy/paste in xl97 and you will see that this is not an option in xl97. So, try pasting values and then pasting formats. ..PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=False ..PasteSpecial Paste:=xlFormats, Operation:=xlNone, SkipBlanks:= _ -- Don Guillett SalesAid Software "Chris" wrote in message ... I have the the following error in Excel 97 (below) when running a macro created in Version 2002. The code line is Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _ xlNone, SkipBlanks:=False, Transpose:=False Error Runtime error 1004 PasteSpecial method of range class failed Can you help on this and tell me what needs to be changed in the line of code above. The code is doing a past special of values and number formats ony Cheers Chris |
What's wrong with what I sent?
..PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=False ..PasteSpecial Paste:=xlFormats, Operation:=xlNone, SkipBlanks:= -- Don Guillett SalesAid Software "Chris" wrote in message ... Oops What I'll do is record a macro in 97 and then paste into my macro. This should do the trick Cheers Chris "Don Guillett" wrote: I didn't say manual. I said manual. So, I guess it depends on what your definition of is is.... I didn't mean to read a manual. I meant to do it manually. The dialog box will not show that option. -- Don Guillett SalesAid Software "Chris" wrote in message ... Thanks I'll try this, don't have a manual hence my problem Chris "Don Guillett" wrote: Have a look at a manual copy/paste in xl97 and you will see that this is not an option in xl97. So, try pasting values and then pasting formats. ..PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=False ..PasteSpecial Paste:=xlFormats, Operation:=xlNone, SkipBlanks:= _ -- Don Guillett SalesAid Software "Chris" wrote in message ... I have the the following error in Excel 97 (below) when running a macro created in Version 2002. The code line is Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _ xlNone, SkipBlanks:=False, Transpose:=False Error Runtime error 1004 PasteSpecial method of range class failed Can you help on this and tell me what needs to be changed in the line of code above. The code is doing a past special of values and number formats ony Cheers Chris |
tried it but didn't work. I may copie in correctly, but many thanks I now hve
it running on an old version, I cannot help feel that I have taken a backward step and should have got my mate to upgrade. oh well Chris "Don Guillett" wrote: What's wrong with what I sent? ..PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=False ..PasteSpecial Paste:=xlFormats, Operation:=xlNone, SkipBlanks:= -- Don Guillett SalesAid Software "Chris" wrote in message ... Oops What I'll do is record a macro in 97 and then paste into my macro. This should do the trick Cheers Chris "Don Guillett" wrote: I didn't say manual. I said manual. So, I guess it depends on what your definition of is is.... I didn't mean to read a manual. I meant to do it manually. The dialog box will not show that option. -- Don Guillett SalesAid Software "Chris" wrote in message ... Thanks I'll try this, don't have a manual hence my problem Chris "Don Guillett" wrote: Have a look at a manual copy/paste in xl97 and you will see that this is not an option in xl97. So, try pasting values and then pasting formats. ..PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=False ..PasteSpecial Paste:=xlFormats, Operation:=xlNone, SkipBlanks:= _ -- Don Guillett SalesAid Software "Chris" wrote in message ... I have the the following error in Excel 97 (below) when running a macro created in Version 2002. The code line is Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _ xlNone, SkipBlanks:=False, Transpose:=False Error Runtime error 1004 PasteSpecial method of range class failed Can you help on this and tell me what needs to be changed in the line of code above. The code is doing a past special of values and number formats ony Cheers Chris |
| All times are GMT +1. The time now is 04:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com