When I record a macro in Excel 97, which copies all except the borders,
then the recorded code says

        Selection.PasteSpecial Paste:=7, .....

which works fine when I run the macro.

However the documentation says I should use

        Selection.PasteSpecial Paste:=xlPasteAllExceptBorders, .....

here xlPasteAllExceptBorders has a value of '6' instead of '7' as in the
recorded macro!!!  This does not run correctly.

What is wrong here???

I use Office 97 Prof. editition, Danish version.

Yours faithfully

S?ren Thade Petersen,