Forum Discussion
VBA Find (What:="") tied to dropdown list box
Hi Fred,
I see the mistake that I made. I hope that the attached version works correctly. You'll notice that there is no Teams dropdown anymore. It isn't needed because the macro loops through all teams.
You only need to select a week, then click the button.
Press Alt+F11 to activate the Visual Basic Editor.
If you don't see the code immediately, click the + buttons in the tree view at the left until you see Module1, then double-click Module1.
Click anywhere in the macro code.
Each time you press F8, one step will be executed.
You can view the value of the variables used in the code by hovering the mouse pointer over them.
A second thought to clean up my worksheet. Where in the worksheet was this that you fixed?
I ran into a couple of inconsistencies:
"There were some teams with "TWO CONSECUTIVE SPACES" on the second sheet; I changed those to single spaces."
Cell B56 contained "ATLANTA FALCONS" with 2 spaces between ATLANTA and FALCONS.
Since the other sheet contains "ATLANTA FALCONS" with one space, the code couldn't find it.
I thought there was another one, but I couldn't find it now.
There were other cells that looked empty but contained (only) two spaces; those don't matter.