How can I modify the expression;

Set myRange = Workbooks(2).Worksheets("Sheet1"). _
Range("E1")

to use a column and row number reference such as Cells(1,5) instead of the
"E1" designation?

When I use;

Set myRange = Workbooks(2).Worksheets("Sheet1"). _
Range.Cells(1, 5)

I get a runtime error.

Thanks,

Keith