View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default Macros created in 2003 won't work in 2000

You need to develope the macros using the lowest common denominator version
(in your case 2000). As a guess your problem will reside in your sort
routines. There in a new argument in the Sort which you can just remove

DataOption1:=xlSortNormal <-Delete this...
--
HTH...

Jim Thomlinson


"dford" wrote:

I have created macros in 2003. They won't work in 2000. Is there a way to
save in an earlier version and make it work. I tried to save it in 97-2000
version and
it still does not work. Is there a way to solve this.