Differences in Excel versions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I ran into a problem where a macro written using Excel 2002 (VBA) would not run on Excel 2000. I don't know if the problem is an incomplete installation of Excel or if there is that much of a difference in the version. When I was debugging the macro on the Excel 2000 system, I noticed that the constant xlPasteColumnWidths was in the "locals" window, as if it were a local variable. Any help?
 
Hi this is a bug

Use the number 8 instead

..Cells(1).PasteSpecial Paste:=8


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)




rwebster3 said:
I ran into a problem where a macro written using Excel 2002 (VBA) would not run on Excel 2000. I don't know if the problem is
Click to expand...
an incomplete installation of Excel or if there is that much of a difference in the version. When I was debugging the macro on
the Excel 2000 system, I noticed that the constant xlPasteColumnWidths was in the "locals" window, as if it were a local
variable. Any help?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA in Citrix. 0
Macro in Different Versions of Excel 4
Win7 VirtualStore Weirdness with Excel 2002 and earlier 60
error when running an excel 2004 macro in excel 2000 2
Trouble Installing Excel VBA Code Cleaner into Office 365 0
2000 vs 2002 xConstants 2
Problem Saving With Different Version 3
Running SPSS-Syntax using Excel VBA (Excel 2013) 0

Back
Top