Forum Discussion
Solved
VBA Find (What:="") tied to dropdown list box
In the VBA Find(What:=), I want the What:=" " to get it's value from a drop down list box in sheet1. I have two worksheets, 1) sheet with three dropdown list boxes 2) sheet with unstructured data w...
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.
Hans,
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."
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.