Okay yes that was on my end I fixed it and it works great, thank you for helping me out with this.
one last question if I save the program will the Macro also save and always be there to use? Or is there a way to permanently save a Macro so I can use in on any excel file I pull up?