Macro Works On My PC But Not On My Colleagues?

[timbo1957]

Hi,

This macro works pefectly on my PC but just stops dead on my colleagues PC at the part of the macro I have made bold.

Any ideas why?

Please Login or Register  to view this content.

[Authentik8]

A sample workbook would help people understand better and make it easier to help you.
What happens if you remove the arguments in question for the Replace line altogether?

[romperstomper]

Are you using different versions of Excel?

[timbo1957]

Hi,

I can't post the workbook because of data protection issues and the actual size of the workbooks itself.

We are using the same version of Excel my colleague gets this message -

When it reaches the bit of macro highlighted in bold

Compile error

Named argument not found

[timbo1957]

Hi,

I can't post the workbook because of data protection issues and the actual size of the workbooks itself.

We are using the same version of Excel my colleague gets this message -

When it reaches the bit of macro highlighted in bold

Compile error

Named argument not found

[romperstomper]

We are using the same version of Excel

That's not possible. If you had the same version you could not get that error on one machine and not the other.

[timbo1957]

I'll check with him later re his version. If he is using a different version is there a workaround for this part of code?

Please Login or Register  to view this content.

[romperstomper]

Remove the last two parameters

Please Login or Register  to view this content.

If I remember correctly, they were introduced with Excel 2002.