
Error in VBA Excel 97 copying all except borders
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,