How to use row and column number instead of "E1" designation?

[keithb]

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

 

[Dodo]

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

What if you leave out "Range."?