Problems with Excel macros on multiple machines

[keywordmonkey]

Hopefully somebody has come across this problem deploying macros on multiple PCs.

I've got a macro that runs fine on a colleague's PC. But on mine (same OS, same Excel version and service pack) it runs differently - namely it doesn't paste some data from sheet1 to sheet2.

I suspect there is a configuration option somewhere that is different between the two machines - but don't know what it is.

Any ideas?

 

[xlbo]

what's the macro ??

Rgds
Geoff
Si hoc legere scis, nimis eruditionis habes

 

[keywordmonkey]

I can't actually post the code because (owned by my employer etc)

However I've just found the smae problem with another macro, this time across 2 PCs.

So it's got to be something more than just one set of code.

 

[xlbo]

I doubt very much that it is something to do with the machine. If the failing is just that it doesn't paste the data then I would be VERY surprised if it is anything to do with the machine. If you can't post the code, it's gonna be very difficult for anyone to help you. Can you at least describe what the code does so we can understand whether it is doing anything that could be affected by computer setup or whether it's probably something in the code....c'mon, throw us a bone here ;-)

Rgds
Geoff
Si hoc legere scis, nimis eruditionis habes

 

[keywordmonkey]

The code looks at the contents of columns A - E on sheet1 and compares them to a set of rules (ma character length, does B contain http: or https: etc) defined in the macro.

If they don't meet these conditions, the offending row should be moved to sheet2 and a message stating the problem placed in column F.

For my collegaue this is fine, but on my machine it puts the message in column A, overwriting the problem row.

Thanks, appreciate this is difficult given the lack of code.

 

[ssVBAdev]

Just a question here but are the "reference styles" set the same on all the PC's (ie. R1C1)? But Geoff is right, we need a little to go on.

 

[xlbo]

So the only difference is that on your machine, the error message overwrites the problem cell instead of being put in col F ???
Can you at least post the code that pastes the data and error messages ????
BTW - for something like this, I'm really surprised that you cannot post the codfe - seems like it ain't that big a deal - it's not like it's from an application or anything

Rgds
Geoff
Si hoc legere scis, nimis eruditionis habes

 

[ssVBAdev]

How about sheet names... can you tell us the names of the sheets? Without seeing the code, at least partially, it's difficult to see what's up.