Can someone please let me know how I would set up a macro which would allow me to put a border around a range of cells only in the event that range was in use. in other words, that range may be all blank in which case I dont want a border. i have named the ranges if this is helpful. thanks.