Why doesn't this method work: {Set wsd.Cells.UsedRange = rng.Cells} ?

I have two questions:
------------------------------------------------------------------------------
------------------------------------------------------------------------------
1: I would like to know why the following code fails at line: Set wsd.Cells.UsedRange = rng.Cells with runtime error 438.
--I've tried many combinations of wsd.Cells = rng.Cells, wsd.Cells.Value = rng.Cells.Value, wsd.Cells(rng.Address).Value = rng.Cells.Value, wsd.Cells(rng.Address) = rng.Cells,...
--I would like to avoid a For-Each loop.
-The goal I'm trying to accomplish is copy cells from one worksheet to another without using the wss.Copy method. Is that possible?
------------------------------------------------------------------------------
2: How can I accomplish my goal?
------------------------------------------------------------------------------

Please Login or Register  to view this content.

Any help is appreciated. I've seen a similar question posted in the forum, but the author lost interest in solving this problem.

PS ...ok I can see how the .UsedRange method would not be used in:
wsd.Cells (especially if there is no Used range in the destination worksheet but I'm still struggling with this when I drop the "UsedRange").

Gatti,

Thanks for the attempt.

Without the Set, I continue to get Error 438: Object doesn't support this property or method.

Usedrange is property of worksheet. Also is read-only.

...Interesting -- I get a not enough memory error when I use line:
wsd.Cells = rng.Cells, which makes sense b/c excel is trying to use ALL cells in the destination workbook.

...so when I run the code by replacing the line that is giving me an error with:
wsd.Range(rng.Address) = rng.Cells, I get no error!

So because I'm after the values, I replace the line with:

wsd.Range(rng.Address).Value = rng.Cells.Value and it WORKS!!!

Here is my corrected code that accomplishes what I was trying to do:
Copy cells onto another worksheet in another workbook w/o using the copy method:

Please Login or Register  to view this content.

Thank you Izandol and Gatti for helping!