Need help using VBA to select entire column as Range

HI..I'm hoping my issue is an easy solve for experts in this forum. I have code that technically works but only because I have made the range a single cell. I simply cannot figure out how to tell VBA to search the entire column for a specific value

Please Login or Register  to view this content.

thank you.

You need to adjust where in column Q to start.

Please Login or Register  to view this content.

F'ing Beautiful!