I really don't want the extra step of the paste option box on a worksheet,
but when I eliminate the appearance of that box it always uses the "match
source formatting" option. I always want to use the "match destination
formatting" option on my worksheets. Isn't there any way to set the default
paste option to "match destination formatting" or am I forced to go through
the extra step every time I copy and paste?