Application Defined or Object Defined Error

[SBF12345]

Greetings,

I am receiving an application defined or object defined error on this line... not sure why this is giving me an error. Variable values are defined as integers. Looks similar to many of the example online, but...

My intention is to set a range object that changes within a loop.

Set arg1 = Workbooks("LOGREG_INPUT.xls").Worksheets("Paper1").Range(Cells(2, a), Cells(e, a))

Thanks!

 

[shg]

Unqualified, those two Cells references refer to the active worksheet.

  With Workbooks("LOGREG_INPUT.xls").Worksheets("Paper1")
    Set arg1 = .Range(.Cells(2, a), .Cells(e, a))
  End With

 

[jim may]

What are the values of the (in red)... a,e,a below. the Cells Function expects numeric,,,

.Range(Cells(2, ​

a​

), Cells(​

e​

, ​

a​

))​

 

[SBF12345]

Thanks shg!

 

[SBF12345]

They are integer values