View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bala[_2_] Bala[_2_] is offline
external usenet poster
 
Posts: 6
Default Run time error : Excel 2000 and Excel 2003 : different behavior of Macro

Hi,

Anyone has a solution for this?

I have an application using Excel Macros. I have developed it with
using Microsoft Excel 2000 under Windows 2003 server. It works fine in
my machine and all the other machines in our organization. But when it
is sent to the Client, client is getting run time error, saying Type
Mismatch in one of the parts of the application and in the other part
saying Method 'Range' of object '_Global' failed. Client end has
Office 2003 under Windows XP Professional. Basically the Type Mismatch
error is coming in a function which has the return value as String
value but used to get double values also. The other error Range
Selection failed is in a function where the range is selected based on
some condition and deleting the particular range.

Any Solutions/Suggestions?

Regards,
Bala.