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

"keithb" wrote in
:

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."?


--

It is I, DeauDeau
(Free after monsieur Leclerc in 'Allo, 'allo)