A
Andrew
Hello,
I have a long excel program which runs fine (and has been running fine
for about a year) on all machines except one. One this one machine I
get some odd behavior. It is as follows:
A user form is used to enter values into cells in one of the
worksheets. There are 5 values, two strings, two currency values, and
1 number. On this one particular machine, the values enter into the
sheet in a repeated form, as if they were part of an array. So, the
userform input number 105.00 would show up on the worksheet as 105.00
105.00 105.00 105.00 105.00 105.00 105.00.
As I said, this code has been running fine on three other machines for
about a year. The only problem I've had is on this one machine. All
machines are using Excel 2007.
Does anyone know if there is a setting in the excel options area which
could affect how the macro runs? Or any other reason why a macro
would run on one machine and not another?
thanks,
Andy
I have a long excel program which runs fine (and has been running fine
for about a year) on all machines except one. One this one machine I
get some odd behavior. It is as follows:
A user form is used to enter values into cells in one of the
worksheets. There are 5 values, two strings, two currency values, and
1 number. On this one particular machine, the values enter into the
sheet in a repeated form, as if they were part of an array. So, the
userform input number 105.00 would show up on the worksheet as 105.00
105.00 105.00 105.00 105.00 105.00 105.00.
As I said, this code has been running fine on three other machines for
about a year. The only problem I've had is on this one machine. All
machines are using Excel 2007.
Does anyone know if there is a setting in the excel options area which
could affect how the macro runs? Or any other reason why a macro
would run on one machine and not another?
thanks,
Andy