Why doesn't Range.copy work in VBA for Excel?

uming you're talking about copying the Range's contents to the clipboard: I'd reckon the Copy method is to create a new Range object that's a copy (with the same range) of the one you invoked the Copy method on.