Problem with Range,Selection, Copy and Paste

[ljunggrenus]

Hello Excel gurus,

My problem is that I want to copy information (nx1) from a workbook to another workbook. Since n should be allowed to change from time to time I would like to use the

Range(Cells(r,c), Cells(r,c))

and copy the vector from that workbook to my main workbook. I do not know if there are any restrictions using the Range-cells-command compared to the ordinary i.e.

("C2:C6")

-version where n is locked at 5. I have used the Windows Activate/Activesheet.Paste command.

Range("C2:C6").Select
                    Selection.Copy

So if you have an alternative way of defining the

Range(C2:C6").Select

command where the row index is allowed to take different values from time to time please help.

Kind Regards,

Peter