I made this spreadsheet for tracking purposes for work. Everything was running smoothly yesterday until they had me add 5 new people to the list. Now there are 5 separate names Dave, Diana, Kathy, Shawn, and Devante. Where if you click on their names at the top of the Tool page you get error 400. Whereas if you choose a different product for a different name to click on they work fine for all others. I have attached the document. Any help would be greatly appreciated.
Thanks!
Jessica
in each sub change the range to include all names
you had the range set to B133
Please Login or Register to view this content.
also add some error code to deal with any blanks cells ie On error resume next
Regards
Sean
Please add to my reputation if you think i helped (click on the star below the post)
Mark threads as "Solved" if you have your answer (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [code]
Please supply a workbook containing example Data: It makes its easier to answer your problem & saves time!
Ahh! Thanks so much =)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks