GUSS Scouting System

[wilsonmw04]

ok, I've been playing with it for a bit and I've run into a few things:
1. When I populate my list of teams, they are not populated as a "hyperlink"
2. When I create new matches from my list and try to save them, I get an error: run-time error '1004' Unable to get the Vlookup property of the WorksheetFunction class.

I select "debug" and it points me to this line of code:
rownum = Application.WorksheetFunction.VLookup(WorksheetFun ction.Text(Str(teamnumber), "@"), Range("A2:Z500"), 19, False)

it seems to be in the part of the code that sets the new value in team page.