Greetings fellow programmers! I am in need of some assistance with
getting a macro that works fine in Excel 2003 to work correctly in
Excel 2000. I understand that the function
"Paste:=xlPasteValuesAndNumberFormats" does not exsist in Excel
2000...however when I try to do a "Paste Value" and "Paste Format" I
get some error telling me "This operation requires the merged cells to
be identically sized." however the paste area is the same exact size
from the columns it uses, row height, and even the border around...its
identical to the original cell I am copying from but I still get this
stupid error message...I was hoping maybe someone could tell me what I
am doing wrong or even supply me some better code...I have already
tried "Paste:=xlPasteValues" and "Paste:=xlPasteFormats" and its not
working correctly in the macro... any ideas? Thanks!