Hello,
Thanks to information found on this group and other web sources I was
able to write my first Excel VBA program and it worked for several
months and then a problem arose.

A breif description of the program; Using Excel as a database to
retrieve material costs. The user clicks on a desktop shortcut and a
workbook loads behind a full screen user form. User selects material
type, gauge, and sheet size from drop down boxes and clicks a command
button to get pricing from up to (10) different vendors.

The workbook w/ the code resides on my machine (Win XP pro). Two
networked machines can access the code via a shortcut on their
desktops. Boss #1 has Win XP Home and boss #2 is running Win 98se ( due
to legacy software that will not run on XP). Boss #1 is working fine
but boss #2 now gets a "run-time error 9" "subscript out of range" when
he clicks the command button to get pricing.

Since the problem only affects 1 computer and even it could run the
program for several months, I don't know where to begin to solve this
problem.

TIA,
Tinknocker