application.vlookup returns Run-error: Object required

Hi all,

I have a macro that I want to use to update username and password.
All is well until I get to the application.vlookup part of the code, and it tells me an object is needed.

I have messed with this until my eyes are bleeding. Any help would be tremendous, thanks!

Windows 7, Excel 2010

Please Login or Register  to view this content.

May be this?

Please Login or Register  to view this content.

Thanks for the response, but sadly that didn't work.

I also tried this with no success either.

Please Login or Register  to view this content.

I read in another thread that my Integer may not work if it doesn't return a number value, so I manually changed it to see if it fixed it, but that didn't seem to work either...

I'll keep at at and post back if i figure it out.

What is User_Login_Database? Is it the codename of a worksheet, or the name you see on the worksheet tab? The latter won't work - you'd have to use Sheets("User_Login_Database")