Convert 2007 Excel Macro to 2003

[eeyeen]

I have this code in Excel 2007 however when I send it to my colleague who is using 2003, he gets
Run-time error'438":
Object doesn't support this property or method
everytime he runs the macro.

Here is the code, can you please advise what is wrong and is there anyway to fix it to have it work on 2003?

Sorry this is clumsy

Please Login or Register  to view this content.

[romperstomper]

Remove both occurrences of:

Please Login or Register  to view this content.

[dominicb]

Good morning eeyeen

...and welcome to the forum!!

The lines I've marked out in red below, won't work in Excel 2003.
Remove them and it should work just fine.

Please Login or Register  to view this content.

HTH

DominicB

[royUK]

This might work, I haven't tried it

Please Login or Register  to view this content.