View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Richard Smolik (Kordia) Richard Smolik (Kordia) is offline
external usenet poster
 
Posts: 1
Default VB Code generates error on another machine?

Hi,

I am currently using Excel 2003 here and have completed a pretty basic VB
code that gets data from one file, sorts, cuts & pastes to a master workbook
and then creates a new workbook from that data based on user input.

The problem I am having is that this little program works perfectly fine on
my Work PC and my PC at home but when someone else at work tries to run the
code it keeps crashing with a Subscript out of range error?

Why does this work on my PCs and not on my workmates who is going to use
this program???? Really frustrating! PLease can anyone help?