On 10/5/2011 8:45 PM, Andrew wrote:
On Oct 5, 7:06 am, wrote:
Andrew wrote :









On Oct 5, 6:47 am, wrote:
Hello,
In using the range method "copy" I have run into some issues with
syntax. Below is some code. I have three statements for copying the
range to a specified destination. Two methods work. But when I use
parentheses around the argument, I get an error. I've encountered
this before. Why would I get an error when putting the argument in
parentheses?

Sub Copy_Ranges()

Dim source_range As Range
Dim dest_location As Range

Set source_range = Worksheets("Sheet1").Range("A1:B2")
Set dest_location = Worksheets("Sheet1").Range("A10")

source_range.Copy Destination dest_location ' this works fine
source_range.Copy Destination:=dest_location ' this works fine
source_range.Copy(dest_location) ' this one
results in an error

End Sub

I've incorrectly typed my command statements. Here is the real code.

source_range.Copy dest_location ' this works
fine
source_range.Copy Destination:=dest_location ' this works fine
source_range.Copy(dest_location) ' this one
results in an error

Parenthesis are used when a return is expected. Think of them as a
'return envelope' used when passing args to a function. The Copy method
does not return anything and so no 'return envelope' is used. In all
cases where returns are expected, the parenthesis are used on the right
side of the equal operator.

--
Garry

Free usenet access athttp://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

I'll have to think about that. That may be over my head. Thanks for
the help.

Andy

I think they discussed the same issue he

http://www.excelforum.com/excel-prog...stination.html