Range Usage in VBA

[Rocky0201]

Hi...

I have a statement (Example 1):

aryVals = Range(.Range("O2"), .Cells(.Rows.Count, "O").End(xlUp)).Value

The above works fine.

What I would like to do is (Example 2):

aryVals = Range(.Range(2, 16), .Cells(.Rows.Count, 16).End(xlUp)).Value

I get a runtime error when trying to use range in this form.

Is there a method that I could use for range in example 2 to accomplish the same as example 1?

Thanks.

 

[njimack]

aryVals = Range(.Cells(2, 16), .Cells(.Rows.Count, 16).End(xlUp)).Value

 

[Rocky0201]

Thanks Neil!!!