In Excel 2000 I would receive the following warning message whenever I would
paste data to an area that was not the same length as the copy area. The
warning message was "the copy area and the paste area are not the same size
and shape."
In both excel 2000 and 2003 I am using the "paste special value" function.
The warning was useful for me because it made sure I was copying / pasting
data to the correct area. The problem is now that I am working with excel
2003 that functionality seems to gone. In excel 2003 I no longer receive the
warning message that says that the copy area is not the same as the paste
area. Whenever I do a copy and paste in exel 2003 the information is pasted
regardless of how many cells I select the pasted area to be. Is their a way
to turn this warning message on in excel 2003?