Forum Discussion
sf49ers19238597
Sep 10, 2023Iron Contributor
I have nfl grid schedule. I press button to put team schedule on own worksheet is error in vba code
I have nfl grid schedule. I press football icon button to put team schedule on own worksheet stop at colts worksheet. is error in vba code
HansVogelaar
Sep 10, 2023MVP
After deleting the existing sheets named after teams, your macro ran without errors.
- sf49ers19238597Sep 10, 2023Iron Contributorwhich worksheet you mean?
- HansVogelaarSep 10, 2023MVP
The sheets named 49ERS, BEARS, BENGALS etc. - in other words, the ones whose name is listed in column B of the TEAMS sheet. The code creates a new sheet for each of these names, but if a sheet of that name already exists, you'll get an error.
- sf49ers19238597Sep 10, 2023Iron Contributor
I just got it work now.
How change code.
How I put @ in column C than put AWAY instead of @.
If no @ in column C. put HOME.
Than remove @ in column B.
for all 32 teams own worksheets.
Bills Sample is should column C look like. I still have @ in column B