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

  • Thread starter Thread starter keithb
  • Start date Start date
K

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
 
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
Click to expand...

What if you leave out "Range."?
 
Back
Top