Method 'range' of object'_global' failed

I am trying to finish my login form and have used this code for the button so that it looks up what accounts are in the workbook and checks if there is a match to what the user has entered as their password and username. Unfortunately part of my code is being flagged up and i cant figure out what is wrong. It is telling me that the VLookup is the problem but I am unsure why. Here is my code and my workbook:

Login Prototype.xlsm

Please Login or Register  to view this content.

substitute all “ ” with "