Hey rajKumar, really thanks for the help but when i ran the macros it said Invalid Selection. I'm not sure what am i suppose to do. Am i suppose to select a cell first then run the macros??

XLD, Honestly Thanks alot man. Your macros works perfectly...