View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default VBA created in excel2003 doesn't work in 2000

There are a number of differences. My best guess (the error that is posted
most often) is that it is crashing on a sort... If you have a sort in your
macro look for this

,DataOption1:=xlSortNormal

and delete it. It is (most likely) not necessary. there are other
differences such as the code for pivot tables, so if the error is not coming
from a sort then post your code...
--
HTH...

Jim Thomlinson


"Sue Robson" wrote:

Hi
I am currently creating a diary using excel 2003 and VBA code. However my
co-workers and other users still only have excel 2000 and unfortunately
various code errors occur rendering the project unusable. Is there a list of
VBA conflicts etc which I can use to trouble shoot this so that I can create
a seperate version for my 2000 users?

This is my first time on a news group - I hope someone can help

Thanks so much

Sue

--
Sue Robson
Consultant Sport Science Director / Head Physiologist
USSA
Email:
Tel/Fax: Australia (61) 2 66245326
Mail: 43 Napier St
Goonellabah, NSW 2480
AUSTRALIA