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



Mon, 16 Apr 2001 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. vba code to copy table from access 97 to excel 97

2. Excel 97 VBA vs Excel 2000 VBA

3. Compatibility Problem Using MS Excel 97 VBA on Excel 2000/XP - Causes crashes

4. VBA code in Excel 97 vs Excel 2002

5. Copying data to Arrays - Excel 97

6. Copying data from Project 98 into Excel 97

7. Copy BLOB's out of Oracle into a file using VBA in Access 97

8. Excel References from Access (97) VBA

9. VBA and Excel 97

10. Access 97 Automation - VBA For Excel

11. Testing VBA in Excel 97

12. Excel 97 VBA code for removing references

 

 
Powered by phpBB® Forum Software