code works in XL 2003 but not 2000

[sedgely]

i have some code in a workbook created in Excel 2003 when i try to run this in Excel 2000 i get an error, the particular bit of code that throws the error is in the "pastespecial" method. the code i have is

Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:=xlNone, SkipBlanks:=False, Transpose:=False

i am assuming that "xlPasteValuesAndNumberFormats" is not supprorted in 2000 how can i get this to work in BOTH versions?

Cheers, Craig
Si fractum non sit, noli id reficere

 

[xlbo]

split it into 2

Selection.Pastespecial paste:=xlValues
Selection.Pastespecial paste:=xlFormats

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[sedgely]

Geoff
Once again you have sorted me out. Thanks

Cheers, Craig
Si fractum non sit, noli id reficere