424 Object required on SOME versions of Excel

Hi all

I have a small application in Excel's VB. When I try to use it, all I get is the "Run time error 424 Object required" error.

However, one of my friend's said it worked without any problem.. I have used Excel 2007 and 2010, both giving me the error.

The line with the problem is highlighted in green:

removed