Find Info code giving object failed error

Using code from http://www.excel-it.com/vba_examples.htm I am attempting to create a search code. I am using Excel from Office 2003

On a user form, the user types in a last name and clicks Find. I would like it to then search column A of sheet 12 (the actual range is row 2 through row 550) and populate a list box with records containing the name entered. When I press Find, I get the following error:

Method 'Range' of object '_Worksheet' failed, and the

Please Login or Register  to view this content.

line of code is highlighted. Can anyone tell me what I've got wrong?

Code:

Please Login or Register  to view this content.