Sorry. Run time Error 9 - subscript out of range

"Jim Rech" wrote:

but my colleague gets a runtime error9.

You should always report the text of the error message, if there is any.
Codes do not usually mean one specific thing.

--
Jim
"kfell" wrote in message
...
| Hello,
|
| I have a macro that runs Ok for me but crashes out with a runtime error
for
| a colleague. The macro opens another spreadsheet, searches through a list
| for a match and then copies information back to the original spreadheet.
It
| runs fine for me but my colleague gets a runtime error9.
| We are using the same version of excel.
| Has anyone got any ideas?