View Single Post
  #1   Spotlight this post!  
Unread 23-02-2009, 14:16
wilsonmw04's Avatar
wilsonmw04 wilsonmw04 is offline
Coach
FRC #1086 (Blue Cheese)
Team Role: Teacher
 
Join Date: Dec 2006
Rookie Year: 2007
Location: Midlothian, VA
Posts: 1,887
wilsonmw04 has a reputation beyond reputewilsonmw04 has a reputation beyond reputewilsonmw04 has a reputation beyond reputewilsonmw04 has a reputation beyond reputewilsonmw04 has a reputation beyond reputewilsonmw04 has a reputation beyond reputewilsonmw04 has a reputation beyond reputewilsonmw04 has a reputation beyond reputewilsonmw04 has a reputation beyond reputewilsonmw04 has a reputation beyond reputewilsonmw04 has a reputation beyond repute
Re: GUSS Scouting System

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.
__________________
Currently: Coach FRC 1086/FTC 93
2006-2011 Coach FRC 2106/FTC 35
If you come to a FRC event to see a robot competition, you are missing the point.