Posted by Jonathan on February 15, 2001 3:49 PM
Why is it, when I manually copy a cell from one report and paste it into another, it works, but when I write a code to do it, it tells me the copy and paste areas aren't the same? The code I am using is below.
Windows("Call Center Summary.xls").Activate
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _