Hi everybody, I'm trying to create VBA that will insert a border around each new cell when it is pasted into an excel sheet. I do not want the borders showing up for cells where nothing has been pasted yet. Anyone have any thoughts on how to accomplish this? This may be more complicated, but I'd also like to have a sheet create a random color each day, then be able to have this single color added to pasted rows in separate excel files, I was thinking maybe this would be possible by linking the tables somehow? Any help would be very much appreciated, thanks!